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 tablespace?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to resolve -917 sql code in DB2?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is RUNSTATS?
what is rebinding ?
What is package versioning? Please give an example.
What are the disadvantages of using VARCHAR?
What is the connection string to connect to the DB2 Database ?
what is REORG? what is the use?
What is a collection?
What is meant by AUTO COMMIT?