Cursor



IBM's flagship relational database management system

Cursor

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

Re: Cursor

 

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
cheers
enrico
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
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Cursor

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

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


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post