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



How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)..

Answer / a.roselin

CURSOR WITH HOLD Option

Is This Answer Correct ?    4 Yes 0 No

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)..

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

Post New Answer

More DB2 Interview Questions

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?

2 Answers   Deloitte,


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

2 Answers   TCS,


How do you run JCL in cobol program

1 Answers   IBM, Syntel,


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?

7 Answers   IBM,


What is the latest version of ibm db2?

0 Answers  


Explain about cursor stability?

0 Answers  


How is a typical DB2 batch program executed ?

1 Answers  


Explain in brief how does db2 determine what lock-size to use?

0 Answers  


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


Mention data types used in db2 ?

0 Answers  


What is the use of value function?

0 Answers  


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 ?

2 Answers   EDS,


Categories