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 the SQL Communications Area and what are some of its key fields?
What is the error code -803 ?
What is meant by union and union all?
How to design maps
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
How to insert more than one record using insert?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is concurrency in db2?
What is check constraint. Explain with example.
What are the abend codes occour in ur latest PROJECT in DB2
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Before you give the explain statement, what are the prerogatives?