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

Which component is used to execute the sql statements?

1147

How to execute stored procedures?

1178

What is a buffer in memory?

1112

What is a storage group (stogroup)?

1286

What is the difference between db2 and oracle?

1178

What do you mean by cursor?

1036

How connect db2 database to datastage?

1291

Is db2 relational database?

1046

How would you find out the total number of rows in a db2 table?

1095

What is a trigger in the db2 database?

1144

What does a deadlock mean in DB2?

1221

what is diffrence b/w file-aid tool and file-aid utility???

4962

What is bufferpool in db2?

1097

Mention some fields that are a part of sqlca.

1098

How do I delete a table in db2?

1126