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

Answer Posted / guest

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

Is This Answer Correct ?    20 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is reorg and runstats in db2?

696


What is db2 stogroup?

676


Are views updateable?

645


What os does db2 run on?

574


How to restart a DB2 program?

1366






What is performance tuning db2?

620


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2379


How do I import data from excel to db2?

615


What is clone table?

592


Is it possible using max on a char column?

609


Give a brief description of db2 isolation levels?

601


How do I create a view in db2?

606


What types of tables are there in the db2 database?

556


How to find primary key of a table in db2?

615