If the cursor is defined with "WITH HOLD" option, it will NOT clo

What happens to a cursor after a commit?

Question Posted / azharuddinsyed

If the cursor is defined with "WITH HOLD" option, it will NOT closed even after the commit operation, else cursor will be closed.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dbrm? When it will be created?

1028

What is dbrm? What it contains? When it will be created?

1047

What is dpf in db2?

1109

How do I import a csv file into db2?

989

How to check last update on table in db2?

1059

Mention some fields that are a part of sqlca.

1021

What is a bind card?

1216

What is package in cobol db2?

1118

What is the use of commit in db2?

1075

What does db2 plan contain?

1019

What is concurrency?

1232

What are bind parameters in db2?

1046

Which component is responsible for processing sql statements and selecting access paths?

1127

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

1034

How will you return the number of records in table?

937