Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / urta
issuing the command "commit" means u have saved the
transaction..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between drop table and delete table?
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 ?
Discuss about db2 bind?
Which component is used to execute the sql statements?
What is a bind card?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Why do we use cursor?
Which is faster delete or truncate?
How can you classify the locks in db2?
What is node in db2?
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 is dpf in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is role in db2?
