Interested to Buy Any Domain ? << Click Here >> for more details...
what is commit & rollback? When and where is used while
compiling a cobol-db2 program?
- 2 Answers
- 22824 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 are db2 tables?
what is db2 restart?
What is isolation level in db2?
How to fetch the last row from the table in SQL (db2)?
What is the physical storage length of date data type?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
List down the types of triggers in the db2 database?
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 the maximum size of a char data type in db2?
How is a typical db2 batch pgm executed?
Can we insert update delete in view?
What is commit in db2?
Is schema the same as database?
What is a trigger in the db2 database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
