What will the COMMIT accomplish?
Answers were Sorted based on User's Feedback
Answer / jdriley
It will make the edits you made to the tables using INSERT,
UPDATE, and DELETE permanent.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / abhisek
COMMIT will save/commit the changes made to a database
while INSERT, DELETE and UPDATE operations.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / as
Commit will clear the content of DB2 buffers.
This point comes to use when you are updating huge nbr of
records without using commit. If the buffer become full
before you commit, then it will cause problem.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / urta
issuing the command "commit" means u have saved the
transaction..
| Is This Answer Correct ? | 0 Yes | 0 No |
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is a page?
How to execute stored procedures?
Which component is responsible for db2 startup and shutdown?
What is the difference between base table and view?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is drop table?
Why cursor is used in db2?
What is difference between isnull and coalesce?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
How do you pull up a query which was previously saved in qmf?