Interested to Buy Any Domain ? << Click Here >> for more details...
i want to know how the commit option works,how it save the
changes? it will update the database or what ? where we can
see these saved changes?
- 4 Answers
- 7094 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Hi,
Mostly we are using commit mass insert and update time
only.suppose i insert 1000 records i am using count varable
i give commit every 100th records means it will
automatically update the data base.so it will affect 999th
records means 900 records ulready update in ur table.so we
can restart 901 records thats enough.you can see in ur
table.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sankar
All changes happens to database are initially made in log,
after successful completion of unit of work (COMMIT),the
changes from log reflected into physical database. In case
of roll-back or un-successful completion, changes will not
be reflested into physical database.
Commit executed at the end of all transaction (explicitly
or inplicitly) irrespective of number of rows affected.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / era
commit will insert a unit of work after some define number
of record processed. That commit point will be taken and
the database updated.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a clustered index?
What do you do to keep the cursor from closing after a commit?
What is a dbrm in db2?
Where would you find information about the type of database authority held by the user?
Can we update view in db2?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
can any one expalin check point with an example?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Is the primary key a clustered index?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
how to get duplicate records from tables?write qurey for this?
How do I delete a table in database?
COBOL 
