Interested to Buy Any Domain ? << Click Here >> for more details...
How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
- 2 Answers
- 9595 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
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.
What type of database is db2?
What is database reorganization?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is runstats 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.
What is db2 and what is the use of db2 optimizer?
What is a db2 collection?
Explain db2.
What is a db2 cursor?
What is temporal table in db2?
B37 abend during spufi?
Explain about rct.
Explain what are the various isolation levels possible?
What is cascading rollback?
