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.
- 3 Answers
- 7025 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehdee
- If you do COMMIT in your program, that means you have
UPDATE, INSERT or DELETE, which in this case you must
DECLARE CURSOR WITH HOLD, then it will not be closed after
COMMIT.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the use of dclgen in db2?
Give a brief description of db2 isolation levels?
List down the data types in the db2 database.
What do you mean by storage group (stogroup)?
what are bind concepts in db2 cobol?
What is explain plan in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How can you find out the # of rows updated after an update statement?
What is page size in db2?
List out the buffer pools in db2
How to retrieve rows from a db2 table in embedded sql?
What is the information associated with sysibm.syslinks table?
How to run db2 command in windows?
What is the use of value function?
Explain about mirror activator disk mirroring?
