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