How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
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 reorg in database?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is declare cursor?
What is db2? Explain.
What is package in db2 mainframe?
What is the max length of sqlca?
How do I create a view in db2?
Explain dclgen.
What happens in bind step in a db2 program?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
what is difference between Static call and Dynamic call? How does it function?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?