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

What does runstats do in db2?

1050

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1059

What is runstats db2?

983

What does a deadlock mean in DB2?

1126

How can you classify the locks in db2?

1053

How do I delete a table in database?

996

What is universal database?

1041

What is iseries database?

1013

What is the difference between db2 and oracle?

1087

What is db2?

1144

What is meant by dclgen?

1078

Mention the downsides of page level lock.

1128

What is ibm db2 database?

971

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

1141

Explain about mirror activator disk mirroring?

976