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 bind card?
What do you need to do before you do EXPLAIN?
What is PRIME TABLE and what are the uses of it
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
How will you delete duplicate records from a table?
how to resolve -811 error. give clear explination
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
Why cursor is used in db2?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What is database manager in db2?