COMMIT will close all the cursors, if the cursors are not delcared using

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 / sridhar

4 Answers
9486 Views
I also Faced
E-Mail Answers

Answer Posted / sridhar

COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.

Is This Answer Correct ?

37 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is runstats db2?

1019

what is db2 restart?

2151

What is the use of runstats in db2?

1104

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1185

How do I import data from excel to db2?

1070

What are the rules for db2 programming?

1087

How is the value function used?

1152

What is null value in db2?

1022

What are host variables in db2?

1070

What is sqlca?

1066

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2840

Give a brief description of db2 isolation levels?

1069

what is utility for parm lib

2371

What is a page in db2?

1025

What language is db2 written in?

1045