You add the keyword "WITHHOLD" to the declare statement of the

What do you do to keep the cursor from closing after a
commit?

Question Posted / guest

Answer Posted / guest

You add the keyword "WITHHOLD" to the declare statement of
the cursor

Is This Answer Correct ?

20 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What do you mean by rollback?

993

List some fields from sqlca?

1062

What do you mean by cursor?

994

Can there be more than one cursor open for any program?

1173

Why do we use cursor?

1106

What is sqlca?

1084

Is db2 relational database?

985

List out the data types available.

1159

What are the contents of a dclmgen?

1135

What is the physical storage length of the data types date, time, and timestamp?

1094

What are catalog tables in db2?

1053

What is dclgen in db2?

1154

How to fetch the last row from the table in SQL (db2)?

1658

What is an instance in db2?

1041

What is buffer pool?

1110