Interested to Buy Any Domain ? << Click Here >> for more details...
What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
- 4 Answers
- 30279 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhisek
As soon as the COMMIT statement is executed in a
program,the cursor gets automatically closed,So we need to
give CURSOR WITH HOLD clause,in order to keep it open after
execution of the COMMIT statement.
| Is This Answer Correct ? | 43 Yes | 2 No |
Post New Answer View All Answers
What is a bind in db2?
How many databases can be created inside an instance in db2 ?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How can deadlocks be resolved?
Is the primary key a clustered index?
What is load utility in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is dpf in db2?
what is the responsibility of the construction superintendent
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How to get the ddl of a table in db2?
What is plan in cobol db2?
What is meant by dclgen?
What is the function of logging in the db2 database?
