What happens to a cursor after a commit?

Answers were Sorted based on User's Feedback



What happens to a cursor after a commit?..

Answer / angoca

The commit will close the cursor if this last was not
declared with the 'with hold' option.

Is This Answer Correct ?    14 Yes 0 No

What happens to a cursor after a commit?..

Answer / guest

The commit will close the cursor.

Is This Answer Correct ?    10 Yes 2 No

What happens to a cursor after a commit?..

Answer / azharuddinsyed

If the cursor is defined with "WITH HOLD" option, it will NOT closed even after the commit operation, else cursor will be closed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


When Can you be sure that a query will return only one row?

4 Answers   IBM,


How do you select a row using indexes in db2?

0 Answers  


Explain the benefits you can get from mainframe connect?

0 Answers  






Explain transactions, commits and rollbacks in DB2.

3 Answers  


Which one allows duplicate values Union or Union All ?

3 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,


Describe major components of db2?

0 Answers  


Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,


What is rct?

0 Answers  


Why do we bind in db2?

0 Answers  


Categories