MVSFORUMS.com

[powerhawk]

I declare and open a cursor in a DB2 database. After some fetch I call a subprogram reading a DL/1 database. When the subprogram terminates the PSB a syncpoint is done. And the syncpoint make the calling program losing the cursor position and I have to declare a new cursor to come back to the earlier row in the DB2 database.
Do anyone know a method to avoid this?

[kolusu]

powerhawk,

Try declaring your cursor with 'WITH HOLD' option. Check this link for a detailed explanation of WITH HOLD

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH10/2.2.2.2?SHELF=&DT=20010209162045&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu