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
7783 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 do we specify index to include or not during bind process.

2125

Explain the function done by data manager?

1273

What is db2?

1172

What is database alias db2?

1121

What is deadlock in db2?

1062

Can you tell me how can you find out the # of rows updated after an update statement?

1095

What do you mean by commit and rollback?

1032

What is declare cursor?

1110

What is page size in db2?

971

How can you count the number of rows from a table tab?

1086

Mention data types used in db2 ?

1152

What is concurrency?

1225

What are the uses of db2 optimizer?

1291

What is the use of db2 optimizer?

1109

Is schema the same as database?

1053