what is commit & rollback? When and where is used while
compiling a cobol-db2 program?
- 2 Answers
- 22307 Views
- I also Faced
- E-Mail Answers
Answer Posted / karthikeyan
Commit:After end of the every permanent Transaction we used
commit.This is most probably used used for record tracking
purpose in the issue log.
Rollback:If any error occur during ur transaction (ex: any
data error) ur procedure will autoimatically call the
rollback procedure and it rollback all the stored record
from the table.u want to use the save point concept while
using the rollback.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is the purpose of rollback and commit?
What happens in bind step in a db2 program?
What is the meaning concurrency in the db2 database?
What is the use of reorg in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What are db2 tables?
Are views updateable?
What is the maximum size of varchar data type in db2?
What is db2 purescale?
Mention the various locks that are available in db2.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is db2 and what is the use of db2 optimizer?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
