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.
- 3 Answers
- 7015 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
How to fetch the last row from the table in SQL (db2)?
What is dbrm? What it contains? When it will be created?
Is the primary key a clustered index?
Explain about cursor stability?
What is buffer pool and list some of them?
How to execute stored procedures?
Highlight all the advantages that are attached to a package.
Is db2 a programming language?
What are bind parameters in db2?
How to find primary key of a table in db2?
How do you find the maximum value in a column in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is clone table?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain about rct in db2?
