Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7662 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 are union and union all?
What is the maximum length of sqlca?
How to create backup table in db2?
Which components manage deadlocks in db2?
Who uses db2?
How to find the maximum value in a column in the db2 database?
What is the role of data manager in the db2 database?
Mention some fields that are a part of sqlca.
What does a deadlock mean in DB2?
What is the physical storage length of the data types date, time, and timestamp?
How is a typical db2 batch pgm executed?
How to run db2 command in windows?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
List down the data types in the db2 database.
How to get the ddl of a table in db2?
