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 |
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is meant by AUTO COMMIT?
What r the comman abends in db2, jcl and cobol???????
Explain the function of data manager.
What does an outer join do?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Explain the contents that are a part of dclgen.
what are the bind parameters?
What is buffer pool and list some of them?
How to design maps
Can we delete records from view?
What is the syntax required for the creation of a cursor?