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 |
How do you check for a null value in a db2 column?
How can you find out the # of rows updated after an update statement?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
what is a collection?
Explain what a plan is?
How do I import data from excel to db2?
What is the function of the Data Manager?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is a db2 tablespace?
How do I start db2 in windows?
How to resolve -818 sql code in DB2?