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 PRIME TABLE and what are the uses of it
How to fetch the uncommited data from table ?
Describe the elements of the SELECT query syntax?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
what needs to be done if a table is in copy pending / check pending status?
Explain how can you do the explain of a dynamic sql statement?
What does it mean if the null indicator has -1, 0, -2?
What is db2 instance?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How to define the a field which accepts value till 99999.99 in db2
what is the name of the default db2 catalog database?
wht steps we need will coding cobol and db2 pgm ?