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