Page 1 of 1

Cursor

PostPosted: Thu Sep 03, 2009 11:01 am
by vaishalisingh
suppose after the Fetch process in Cursor my program sudeenly abends, in that case what would be the state of my cursor after the abend ?

Re: Cursor

PostPosted: Thu Sep 03, 2009 2:56 pm
by enrico-sorichetti
since the program abended, nobody will be there to worry,

from a db2 point of view...
all the updates (up/down to the last commit) will be backed out
all the locks will be released

Re: Cursor

PostPosted: Fri Sep 04, 2009 12:38 am
by dick scherrer
Hello,

after the Fetch process in Cursor my program sudeenly abends,
How might this cursor abend suddenly?

Do you mean there was a system or user abend or simply that some unwanted sqlcode was returned from a fetch (or other sql statement)?

If you explain in detail what happened, you will get more specific (rather than generic) replies. . .