Interested to Buy Any Domain ? << Click Here >> for more details...
what happend with out using Commit,when closing cursor and
program?
- 5 Answers
- 15231 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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What language is db2 written in?
How to compare data between two tables in db2?
Explain about open switch business continuity software?
How to check last update on table in db2?
What is node in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
what is the responsibility of the construction superintendent
What is ibm db2 connect?
what is utility for parm lib
what is diffrence b/w file-aid tool and file-aid utility???
How do I import data from excel to db2?
What does db2 mean?
What are the two types of logging in the db2 database? Explain them.
What is cobol db2?
