Interested to Buy Any Domain ? << Click Here >> for more details...
what happend with out using Commit,when closing cursor and
program?
- 5 Answers
- 15030 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 schema in db2?
Is ibm db2 free?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a bind card?
Mention some fields that are a part of sqlca.
Before you give the explain statement, what are the prerogatives?
What is ibm db2 used for?
What is with ur in db2?
What is copy pending and check pending in db2?
What are the contents of dclgen?
What is clone table?
Explain about rct.
What's The Error Code For Unique Index Voilation?
What os does db2 run on?
What is the difference between cursor and select statement?
