IBM's flagship relational database management system


Postby vaishalisingh » Thu Sep 03, 2009 11:01 am

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 ?
Posts: 5
Joined: Mon Aug 24, 2009 1:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Cursor

Postby enrico-sorichetti » Thu Sep 03, 2009 2:56 pm

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
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Global moderator
Posts: 2999
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Cursor

Postby dick scherrer » Fri Sep 04, 2009 12:38 am


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. . .
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post