Interested to Buy Any Domain ? << Click Here >> for more details...
What will the COMMIT accomplish?
- 5 Answers
- 7630 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 dbrm? When it will be created?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
What is a lock?
What is sqlcode -922 ?
My SQL is not performing well. Describe how will you fine tune it?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the difference between dbm cfg and db cfg file in db2 ?
How to know the primary key of a table without defining the primary key in the table?
What is cascading rollback?
What are simple, segmented and partitioned table spaces ?
how do u update the faltfile into db2 table ?
What does db2 stand for?
COBOL 
