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

What is cobol db2?

998

What are bind parameters in db2?

1045

How many databases can be created inside an instance in db2 ?

1033

How to connect to db2 database from windows command line?

1061

What is cursor with hold option in db2?

1069

Why db2 is called db2?

1036

Explain packages.

1109

How to run db2 command in windows?

1192

What is the difference between plan and package in db2?

1109

How to rename a table in DB2 ?

1088

What is check constraint. Explain with example.

1103

How do you eliminate duplicate values in db2?

1180

Comment whether the cursor is closed during commit or not.

1100

Where do you specify them?

1275

Give the name of some fields form sqlca.

1075