Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

cursor with hold

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
harivasukrishnan

New User


Joined: 07 Feb 2006
Posts: 2

PostPosted: Sun Jun 27, 2010 11:29 am    Post subject: cursor with hold
Reply with quote

Hi buddies,

I have a cursor declared with the 'with hold' option.Now my program abnormally terminates which means that commit is not issued.Could you please tell me the status of the cursor?Will be in the open status?Can I restart the program so that the cursor will fetch the next eligible record from db?If the cursor is in open stage even after the abort where db2 will store the cursor pointer?What happens if a roll back is issued while aborting?

I faced these questions in an interview.Emphasis was on the significance of 'with hold' option in the restart logic.Experts please have a look on it..

Thanks,
Hari.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jun 27, 2010 11:33 am    Post subject:
Reply with quote

Hello and welcome to the forum,

When a process terminates (ends/abends), all cursors cease to exist. . .
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Jun 27, 2010 11:41 am    Post subject: Re: cursor with hold
Reply with quote

harivasukrishnan wrote:
I have a cursor declared with the 'with hold' option.Now my program abnormally terminates which means that commit is not issued.
Quote:
Could you please tell me the status of the cursor?
What cursor, it disappeared with the abend.
Quote:
Will be in the open status?
As above, no.
Quote:
Can I restart the program so that the cursor will fetch the next eligible record from db?
As above, no.
Quote:
If the cursor is in open stage even after the abort where db2 will store the cursor pointer?
As above, nowhere.
Quote:
What happens if a roll back is issued while aborting?
Isn't that the usual default, rollback upon abend?
Quote:
I faced these questions in an interview.Emphasis was on the significance of 'with hold' option in the restart logic.
AFAIK, the HOLD option applies across commits, not abends.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sun Jun 27, 2010 3:35 pm    Post subject:
Reply with quote

Quote:
significance of 'with hold' option in the restart logic.


the 'with hold' option has nothing to do with restart logic.

you got lost at that point.
Back to top
View user's profile Send private message
harivasukrishnan

New User


Joined: 07 Feb 2006
Posts: 2

PostPosted: Wed Jun 30, 2010 11:21 pm    Post subject: Reply to: cursor with hold
Reply with quote

thank you buddies for all your kind replies....have a great time!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am
No new posts How LOAD PROGRAM and LOAD on HOLD is ... pkmurali CICS 4 Tue May 03, 2016 6:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us