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

Which are the db2 tools to protect integrity of the database?

1108

Explain in brief how does db2 determine what lock-size to use?

1020

Name the lockable units in DB2?

1109

Can you tell me how can you find out the # of rows updated after an update statement?

1079

What is dbrm in db2 database?

1091

What is rct?

1208

What is null in db2?

999

what is the responsibility of the construction superintendent

2130

What is a dbrm in db2?

1007

How do you eliminate duplicate values in db2?

1141

What is the use of db2 optimizer?

1085

What is the syntax for FETCH in DB2 ?

1187

What is package in db2 mainframe?

966

How to compare data between two tables in db2?

1062

What is node in db2?

1033