what happend with out using Commit,when closing cursor and
program?

Answer Posted / mani

The answer to the question is pretty simple and straight.

Auto commit happens when the cursor is closed.
If at all there is any abend then the changes made will be lost.

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbrm in db2 database?

591


What is dbrm? What it contains? When it will be created?

595


How many types of page locks can be held in db2?

593


How do I delete a column in db2?

680


What is bind and rebind in db2?

652






Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630


What is node in db2?

610


what is utility for parm lib

1885


What is the use of with ur in db2?

617


Why cursor is used in db2?

577


How to run db2 command in windows?

654


What does db2 mean?

589


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?

6862


What do you mean by commit and rollback?

597


How to take backup of table in db2?

601