DB2 cursor close if commit issued

1 post / 0 new
Anonymous
DB2 cursor close if commit issued

 

 

 

Hi All,

I have declared and opened a cursor in program A and before fetching the data from cursor, program A calls another  program B. 

Program B has a commit statement. After the call to program "B", the fetch is issued on the cursor, would the data be fetched or there will be an sql error stating that the cursor is closed.

What I exactly wish to know is that if a Cursor is opened without Hold option in a calling program and the called program issues a commit, would the cursor be closed?

Any inputs are welcome!

"; ; ; ;
Sponsored Listing