If you like the cursor maintain the position even after the commit, CURSO

How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)

Question Posted / s

Answer Posted / s

If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1090

What is the maximum size of a char data type in db2?

1012

What is ibm db2 database?

1007

How do we specify index to include or not during bind process.

2128

What is meant by union and union all?

1012

What is node in db2?

1044

How do I add a column to an existing table in db2?

1032

What are the full forms of spufi and dclgen and why are they used?

1091

Give a brief description of db2 isolation levels?

1074

Describe major components of db2?

1095

How does db2 sample database connect?

1034

What is the use of db2 optimizer?

1117

How can you count the number of rows from a table tab?

1093

How to access db2 tables in mainframe?

1055

What is runstats utility in db2?

1021