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?
Answer Posted / 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 |
Post New Answer View All Answers
What's The Percentage Free Space ?
Explain what are the various isolation levels possible?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What are the bind parameters ibm db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Give a brief description of db2 isolation levels?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Can you tell me how can you find out the # of rows updated after an update statement?
What are host variables in db2?
How and when does the db2 enforces the unique key?
What is package in cobol db2?
Highlight all the advantages that are attached to a package.
What is the default page size of buffer pools?
What are the various data types available in db2?
How many databases are there?