Answer Posted / azharuddinsyed
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 |
Post New Answer View All Answers
What are the contents of a dclmgen?
List out the three types of page locks that can be held.
What is runstats and reorg in db2?
What happens in bind step in a db2 program?
What is a dbrm in db2?
Is schema the same as database?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the result of open cursor statement?
What is ibm db2 database?
Name the various locking levels available?
What is the difference between drop table and delete table?
What are the uses of db2 optimizer?
What is host variable in db2 cobol?
What is node in db2?
What is declare cursor?