The progam abends and there is code that rollsback the data. There is also code that allows the re-processing of the data. In cursor one, the re-processing works, in the second cursor, the re-processing has no data to process. If there are no commits, the second cursor should also be rolledback and the re-process process the data. This does not happen in my test environment. Is there a pre-compile or bind parm that allows this, that I am missing?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open Cusor & Rollback
- Thread starter DB2Bill
- Start date