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
What do you mean by commit and rollback?
What is the result of open cursor statement?
What is dbrm in db2 database?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is runstats utility in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What action db2 takes when a program aborts in the middle of a transaction?
How to connect to db2 database from windows command line?
What is db2 stogroup?
Can there be more than one cursor open for any program?
What are the benefits of using the db2 database?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What do you mean by between and in? Is between inclusive of specified range values?
How to fetch the last row from the table in SQL (db2)?
When the like statement is used?