A held cursor can be closed when 1.CLOSE cursor is issued. 2.ROLLBACK is

wht happens if we close cursor with cursor with hold option?

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

A held cursor can be closed when
1.CLOSE cursor is issued.
2.ROLLBACK is issued.
3.Application terminates.

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to find primary key of a table in db2?

1001

What is explain plan in db2?

941

What is db2 purescale?

942

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2122

What is the difference between cursor stability and repeatable read isolation levels?

1114

What is drop table?

958

What is the default page size of buffer pools?

1069

What is the use of dclgen in db2?

1011

What is check constraint. Explain with example.

1043

What is db2? Explain.

986

Which component is responsible for db2 startup and shutdown?

980

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1974

Explain various types of locks in db2?

1080

Can there be more than one cursor open for any program?

1123

How can we read records for specific member in CL? AND rpg?

643