What should be specified along with a cursor in order to continue updating pro

What should be specified along with a cursor in order to
continue updating process after commit?

Question Posted / guest

What should be specified along with a cursor in order to continue updating process after commit?..

WITH HOLD

Is This Answer Correct ?

4 Yes

0 No

More DB2 Interview Questions

Is db2 a mainframe database?

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

What is ACQUIRE/RELEASE in BIND?

Is it possible to precompile if db2 goes down?

What is the cascade rule and how does it relate to deletions made with a subselect?

Why db2 is called db2?

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

What is the max length of sqlca?

Can one database have multiple instances?

is it compulsory commitment control in journal?

For more DB2 Interview Questions Click Here