SQL cursor status after program abend

vch · New User Joined: 01 Feb 2008 Posts: 22 Location: chennai

In my program i have a cursor..if my programs abends in the middle did the cursor will close automatically?

XungoPejcao · New User Joined: 04 Sep 2008 Posts: 7 Location: Espa�a

Yes, normally when one finds a not controlled return of db2, and abend the program, the cursor remains closed.
The cases in which you can found sqlcode -502 (the cursor identified in an open statement is already open) are because the program has finished without there be executing the statement EXEC SQL CLOSE CUR-NN END-EXEC.

vch · New User Joined: 01 Feb 2008 Posts: 22 Location: chennai

I didn't get you Xungo...in program, before executing cursor close statement, if program abends then will that cursor close automatically or when we run that program again after the abend it will give -502?

Suresh Ponnusamy · Posted: Mon Sep 22, 2008 7:47 pm Post subject:

Hi

Yes.. I will get closed.