Interested to Buy Any Domain ? << Click Here >> for more details...
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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the maximum length of sqlca?
What are the various isolation levels possible?
Outputs of explain are with matchcols = 0. What does this signify?
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.
Which command is used to remove all rows from a table?
How do I import data from excel to db2?
Define check constraint.
Differentiate between cs and rr isolation levels? Where do you specify them?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What do you mean by commit and rollback?
What is the difference between bind and rebind in db2?
Is ibm db2 open source?
Explain about cursor stability?
How do I delete a column in db2?
