WHEN THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN,then

a cursor normally gets closed once we provide a commit . If
u try to close the same cursor with close cursor command
later after providing the commit will there be any sql-error.

Question Posted / manasa

3 Answers
7807 Views
I also Faced
E-Mail Answers

Answer Posted / manasa

WHEN THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS
NOT OPEN,then we get -501 error.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of page locks can be held in db2?

1044

what is the role of the cursor in db2?

1069

How do I add a column to a table in db2?

1104

What is dpf in db2?

1112

What is precompiler in db2?

1023

What is the information associated with sysibm.syslinks table?

1125

Is schema the same as database?

1060

How to find the number of rows in a db2 table?

1120

What is the meaning concurrency in the db2 database?

1111

Mention data types used in db2 ?

1163

What is cobol db2?

1003

List down the data types in the db2 database.

1125

Explain in detail about buffer manager and its functionalities?

1068

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1149

What is the difference between bind and rebind in db2?

1453