|
View previous topic :: View next topic
|
| Author |
Message |
nileshyp
New User
.jpg)
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 |
|
|
|
|
