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
- 7932 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 sqlcode -501
How to check sequence on a table in db2?
How many types of page locks can be held in db2?
What is deadlock in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are the uses of db2 optimizer?
What action db2 takes when a program aborts in the middle of a transaction?
What is a storage group (stogroup)?
What is ibm db2 database?
What is database reorganization?
How to view db2 table structure?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is buffer pool and list some of them?
