How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
- 2 Answers
- 8840 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 |
What is dbrm library?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
what is copy pending and check pending ?
How does DB2 use multiple table indexes?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is the function of logging in the db2 database?
What is the difference between drop table and delete table?
Is db2 a programming language?
What is host variable in db2 cobol?
what is consistency token
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
List some fields from sqlca?
COBOL 
