Interested to Buy Any Domain ? << Click Here >> for more details...
what happend with out using Commit,when closing cursor and
program?
- 5 Answers
- 15253 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / guna
If there is no commit while closing cursor or a program,
processed records are lost when an abnormal end occurs.
Say, if due to the execution of the program some rows are
inserted/deleted/updated in a table, those changes will be
lost.
It is a better practice to give commit after every
insertion/updation queries and before terminating a
program.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the difference between oracle and db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How does coalesce work?
What is buffer pool and list some of them?
What is a bind card?
How to find the number of rows in a db2 table?
What is cascading rollback?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Define check constraint.
When reorg is used?
What are catalog tables in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
How to create backup table in db2?
How will you return the number of records in table?
What are the contents of dclgen?
