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 |
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
what is Static and dynamic linking
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is lock contention?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What is the advantage in De-normalizing tables in DB2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What are the functions of Bind?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are some SQL aggregates and other built-in functions?
What is the use of COMMAREA ?Minimum how much data we can pass from it?