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 |
What is the role of the data page in the db2 database?
What will the DB2 optimizer do?
What is phantom read in db2?
What is the error code -803 ?
What do you mean by storage group (stogroup)?
Is ibm db2 free?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
How to handle null values in db2
what is the use of commit ? and what is the syntax?
Explain the benefits you can get from mainframe connect?
How do I import data from excel to db2?
how can we retrieve the 100 records of the file ?