CURSOR WITH HOLD Option

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

Question Posted / a.roselin

Answer Posted / a.roselin

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1030

How to find the number of rows in a db2 table?

1063

What is cascading rollback?

1133

Define db2.

1064

Explain various types of locks in db2?

1081

What are the contents of dclgen?

1053

Explain about dbrm.

988

What are concurrency issues?

1029

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11615

How does a cursor work?

928

How does db2 sample database connect?

972

How to create db2 table in mainframe?

1103

What is the use of reorg in db2?

1024

What is difference between alias and synonym in db2?

1067

What are foreign keys in db2?

1034