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.
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
Outputs of explain are with matchcols = 0. What does this signify?
What are the full forms of spufi and dclgen and why are they used?
what is the sqlcode -501
Is db2 a mainframe database?
How do you find the maximum value in a column in db2?
what is the role of the cursor in db2?
Explain about dbrm.
What is check constraint. Explain with example.
Are views updateable?
Why do chiropractors use drop table?
What are iseries servers?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is db2 and what is the use of db2 optimizer?
What is a db2 schema?
What is runstats utility in db2?