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

Mention some fields that are a part of sqlca.

972

How do I delete a table in database?

977

What is a db2 schema?

1175

How do I import data from excel to db2?

1015

What is a bind card?

1145

What happens in bind step in a db2 program?

916

What is package in cobol db2?

1079

What is the difference between db2 and oracle?

1070

How do I change the column size in db2?

1084

What is consistency token in db2?

1067

Explain about rct in db2?

1046

Which components manage deadlocks in db2?

1021

define clustering index.

980

How can we retrieve the total number of records in RPG & CLLE?

581

How connect db2 database to datastage?

1191