What happens to a cursor after a commit?
Answers were Sorted based on User's Feedback
Answer / angoca
The commit will close the cursor if this last was not
declared with the 'with hold' option.
| Is This Answer Correct ? | 14 Yes | 0 No |
If the cursor is defined with "WITH HOLD" option, it will NOT closed even after the commit operation, else cursor will be closed.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a page?
What are iseries servers?
How can you find out the # of rows updated after an update statement?
What is cursor stability?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is plan in cobol db2?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
what's the best lock size that you could use when you create a tablespace?
What are some characteristics of columns that benefit from indexes?
when does the SQL statement gets executed when you use cursor in the application programming ?
Once you create a view, where would information about the view be stored?
B37 abend during spufi?