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
- 7801 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 the contents of dclgen?
How do I delete a table in database?
What are the different types of base tables?
can we view the access paths created by dbrm ? how ? thx
What is access path in db2?
What is the max length of sqlca?
Which isolation level provides maximum concurrency?
How do you stop a db2 database in linux?
What is concurrency?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is package in db2 mainframe?
What is clone table?
What is the meaning concurrency in the db2 database?
Define buffer pool.
