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
- 6634 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 bind package and plan in db2?
What is collection in db2 bind?
Are views updateable?
How many types of page locks can be held in db2?
Can we delete records from view?
How to get the ddl of a table in db2?
What is phantom read in db2?
Explain in brief how does db2 determine what lock-size to use?
What is db2 catalog database?
Mention some fields that are a part of sqlca.
What are the various data types available in db2?
Highlight all the advantages that are attached to a package.
Explain correlated sub-queries.
What is a cursor in programming?
What are the 2 sqlcodes that are returned?
