View previous topic :: View next topic
|
Author |
Message |
nileshyp
New User
Joined: 22 Jun 2005 Posts: 65 Location: Mumbai
|
|
|
|
I would like to have clarification on the following doubt:-
I have Declared a cursor "WITH HOLD" option.
So where will be the cursor pointer when I CLOSE the cursor and reopen the same CURSOR, is it at the Last record processed?
Kindly answer above query if you are very sure.
No guessing please..!!! |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
WITH HOLD only keeps the cursor position when you do a COMMIT, if you close and open a cursor you are back to beginning! |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
is it at the Last record processed?
|
DB2 does not have records, selects/fetches do not return records, they return rows.
since you obviously want accurate answers, you should phrase your questions accurately. |
|
Back to top |
|
|
nileshyp
New User
Joined: 22 Jun 2005 Posts: 65 Location: Mumbai
|
|
|
|
Thanks Craq Giegerich & CICS Guy.. for your guidance.
dbzTHEdinosauer... Since I have already got my answer from two gentlemens who interpreted my question in right sense.
But Anyway.. thanks for ur suggestion.. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
deleted by poster |
|
Back to top |
|
|
|