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 a db2 cursor?

1106

Are views updateable?

1234

What is the difference between plan and package in db2?

1167

What is rct?

1287

What is buffer pool?

1158

What is db2 purescale?

1052

What is the syntax for FETCH in DB2 ?

1263

Explain what are the various isolation levels possible?

1094

What does a deadlock mean in DB2?

1215

What is db2 catalog database?

1088

Why db2 is called db2?

1105

What is dclgen (declaration generator)?

1111

How to check last update on table in db2?

1097

How would you find out the total number of rows in a db2 table?

1094

Mention some fields that are a part of sqlca.

1091