I am getting a return code 94 (100) on a job that uses SQL triggers. What can cause this?

book

Article ID: 14395

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction



I am getting a return code 94 (100) on a job that uses SQL triggers. What can cause this?

Environment

Release: DATABB00200-14-Datacom/AD
Component:

Resolution

A return code 94(100) is generated when a navigational application triggers an SQL procedure and that procedure receives an error.

If the program is inserting rows into another table it could be failing with a return code 07 or 08. Or maybe that other table is inaccessible. There can be many reasons, you need to examine the actual return codes produced by the trigger itself which may be found in the Request Area in the dump either in the PXX or the PXXMLnn SYSOUT.

If the dump has been suppressed, you can use the RCERROR YES,NO,94100 console command to produce the dump.

In the dump search for the DBRW---n (where n is the task number that appears in the dump header for the RC 94(100)). Then look at the user request area starting at offset x'100'  then the DBRQDIAG area located at offset x'1C' into the user request area. It contains  the following:

4-byte SQLCODE 

2-byte external return code

1-byte internal return code

5-byte SQLSTATE. 

 

Additional Information

See in DocOps the description of RETURN CODE 94