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 do you resolve -805?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
How to resolve deadlock issue
what's the error code for Unique Index Violation?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What is Call attach facility? How does it work?
How does the processing of a correlated subquery differ from a non correlated subquery?
what needs to be done if a table is in copy pending / check pending status?
Why db2 is called db2?
How do I connect my db2 database to ibm?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE