CA Tuesday Tip: (CA IDMS) Error Handling in Database Procedures

Discussion created by Eddy_G Employee on Nov 27, 2013
CA IDMS Tuesday Tip by Edward Gorga, Principal Support Engineer for November 26, 2013.
Database procedures run in system mode so if there is an abend in a database procedure it will cause the whole IDMC CV to abend.Any error handling routine in the procedure should avoid doing anything that will cause a failure. If you are issuing DML calls do not call the ABORT routine for unexpected error status codes as this will abend the whole CV. More details on this are available in TEC600624For details on coding database procedures see the Database Administration Guide,  Chapter 16 "Writing Database Procedures".