What happens to a cursor after a commit?

Question Posted / guest

3 Answers
9778 Views
I also Faced
E-Mail Answers

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

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

Explain various types of locks in db2?

0 Answers

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers IBM,

What is a collection?

3 Answers

what are extents?

5 Answers

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers IBM,

Explain the function of data manager.

0 Answers

What information is held in SYSIBM.SYSCOPY?

1 Answers

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.