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

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

Question Posted / guest

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

Answer / guest

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

Is This Answer Correct ?

20 Yes

0 No

More DB2 Interview Questions

What are common abends

What is ibm db2 used for?

What is the latest version of ibm db2?

What is db2 purescale?

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

What if we fail to give values in columns declared as NOT NULL ?

What is the command used by TSO users to invoke DB2?

wht steps we need will coding cobol and db2 pgm ?

How to define the data items to receive the fetch items for the SQL?

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

select 100 records from million records ?

What are bind parameters in db2?

For more DB2 Interview Questions Click Here