How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
- 2 Answers
- 8482 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 |
How to find the number of rows in db2 tables?
How can you count the number of rows from a table tab?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Suppose if I need to update a column, how you do that using cursor?
What are the disadvantages of PAGE level lock?
Mention the location where the output received from explain statement is stored.
How to update more then one record using update?
What are the four lockable units for DB2?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How do you insert a record with a nullable column?
What information is used as input to the bind process?
What is the physical storage length of timestamp data type?
COBOL 
