Interested to Buy Any Domain ? << Click Here >> for more details...
How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
- 2 Answers
- 9708 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.
| Is This Answer Correct ? | 4 Yes | 0 No |
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What is alias in db2?
How to fetch the last row from the table in SQL (db2)?
What does the RUNSTATS Utility do?
difference between group clause and order clause
How does DB2 store NULL physically?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What r the comman abends in db2, jcl and cobol???????
What is the difference between oracle and db2?
How to resolve -803 sql code in DB2?
what is cursor stability?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
COBOL 
