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
- 6348 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
Highlight all the advantages that are attached to a package.
What is cobol db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to check table size in db2 sap?
What is the use of value function?
How to run db2 command in windows?
What are the different types of base tables?
What is meant by union and union all?
How do you select a row using indexes in db2?
What are the various data types available in db2?
Can we delete records from view?
What is rct?
What is null value in db2?
How to connect to db2 database from windows command line?
How do I delete a column in db2?
