Answer Posted / 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 |
Post New Answer View All Answers
Comment whether the cursor is closed during commit or not.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is null value in db2?
is it compulsory commitment control in journal?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is bind and rebind in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the uses of db2 optimizer?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the physical storage length of date data type?
What is catalog database in db2?
What are db2 tables?
How do I delete a table in db2?
Which component is responsible for processing sql statements and selecting access paths?
What parameters are used to control the free space in DB2?
