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 |
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How do you run JCL in cobol 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 the latest version of ibm db2?
Explain about cursor stability?
How is a typical DB2 batch program executed ?
Explain in brief how does db2 determine what lock-size to use?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
Mention data types used in db2 ?
What is the use of value function?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?