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

What is meant by dclgen?

0 Answers  


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  


What is performance tuning db2?

0 Answers  


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,






I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  


What is package in db2 mainframe?

0 Answers  


How can you count the number of rows from a table tab?

0 Answers  


what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  


What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,


i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  


when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,


Categories