Interested to Buy Any Domain ? << Click Here >> for more details...
What will the COMMIT accomplish?
- 5 Answers
- 7845 Views
- I also Faced
- E-Mail Answers
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 QUIESCE?
What is coalesce in db2?
What is the use of dclgen in db2?
What are the functions in DB2?
What is meant by the attachment facility?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
How to update more then one record using update?
When do you specify the isolation level?
What does db2 plan contain?
What is meant by a unit of recovery?
What os does db2 run on?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
COBOL 
