ECPG: AUTOCOMMIT and CURSORs

[A J <s5aly@xxxxxxxxx>]

I am seeing some funny behavior on using both:

EXEC SQL SET AUTOCOMMIT TO ON;

and

CURSORS (EXEC SQL DECLARE ............., EXEC SQL FETCH NEXT FROM .............)

On autocommit on (either through above method or precompiling with -t option), the cursor does not return any rows. On disabling autocommit, I get the required number of rows from the cursor.

Any idea what could be going on ? 

Thanks!

AJ