How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
- 2 Answers
- 8451 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 |
Normalization in DB2 – first normal form, second normal form
What is ibm db2 client?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
Mention the various locks that are available in db2.
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
db2 restart logic ?
Explain about rct in db2?
What is tablespace?
What are the uses of db2 optimizer?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is a buffer pool?
Where could you look if you had a question about whether a column has been defined as an index?
COBOL 
