Interested to Buy Any Domain ? << Click Here >> for more details...
What will the COMMIT accomplish?
- 5 Answers
- 8001 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 |
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What are db2 objects?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What are the disadvantages of using VARCHAR?
What do you mean by storage group (stogroup)?
What is a composite index and how does it differ from a multiple index?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is database reorganization?
How would the varchar column remarks defined?
What are foreign keys in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
COBOL 
