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 schema in db2?

1022

What does sqlcabc has?

1054

What is multi row fetch in db2?

1050

Highlight all the advantages that are attached to a package.

1119

How to execute stored procedure in db2 command editor?

1049

What is the use of dclgen in db2?

1085

Is the primary key a clustered index?

1149

Why select is not preferred in embedded sql programs?

1299

What is scrollable cursor in db2?

1055

How do I change the column size in db2?

1157

How does a cursor work?

988

What is view db2?

1076

What is node in db2?

1044

How does coalesce work?

1021

How can the duplicate values be eliminated from db2 select?

1106