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

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• 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