COMMIT WILL CLOSE ALL THE CURSORS IF U R NOT MENTIONED WITH HOLD OPTION IN

I have 3 cursors declared. Cursor1 retieves some data.
Based on this curso2 will also fetches some data. In cursor3
(using for some updation) I'm using the data retrieved by
the above 2 cursor. My question is, while working with
cursor3, periodically if I give commit, will all the three
crsors will be closed or only cursor3 will be closed?

Question Posted / r.l.v.krishna

4 Answers
9653 Views
I also Faced
E-Mail Answers

Answer Posted / r.l.v.krishna

COMMIT WILL CLOSE ALL THE CURSORS IF U R NOT MENTIONED WITH HOLD OPTION IN THE DECLARATION PART OF THE CURSOR....

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 plan table?

1109

what are bind concepts in db2 cobol?

1137

What is the syntax for FETCH in DB2 ?

1264

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1138

What is lock escalation in db2?

1079

How does a cursor work?

1037

What is cursor stability in db2?

1414

How to find schema of a table in db2?

1065

What is a db2 schema?

1296

How to execute stored procedures?

1175

What is sqlca?

1128

What are iseries servers?

1128

What is load replace in db2?

1044

What is meant by explain?

1193

What are the benefits of using the db2 database?

1287