what happend with out using Commit,when closing cursor and
program?
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 ibm db2 used for?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is sqlca’s maximum length?
What is db2 and what is the use of db2 optimizer?
What is the advantage in De-normalizing tables in DB2?
what is the role of the cursor in db2?
What is page size in db2?
Is ibm db2 free?
What is the maximum length of sqlca?
What are the contents of dclgen?
How does coalesce work?
What is an instance in db2?
What is the role of data manager in the db2 database?
Are view updateable?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.