Explain transactions, commits and rollbacks in DB2.
Answer Posted / deepak
Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.
Commit-is use to save the records in data base for ex, I
have hundred records I got an abend in 50th records I can
save upto 49 records, and solve the issue and continue from
50th records,
Roll Back- it do not save the records if any abend occurs
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the responsibility of the construction superintendent
What is isolation level in db2?
What is reorg?
List out the three types of page locks that can be held.
Comment whether the cursor is closed during commit or not.
How do you eliminate duplicate values in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is host variable in db2 cobol?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is dbrm?
what are bind concepts in db2 cobol?
What is reorg and runstats in db2?
What are iseries servers?
How do I copy a table in db2?
What are the various isolation levels possible?