Setting up SQL return code options

AR/CTL can intercept a defined SQL return code received during application program processing and issue a defined user abend code and reason code. This abend code and reason code can be defined as a combination that is eligible for application reattach processing.

To set up SQL return code handling, create or update a processing option record that applies to the application program execution. In this processing option record, set the Intercept SQL Return Codes option to Y. Set the SQL Return Code Class Name option to the name of the SQL return code class record that defines (or will define) the SQL return code options you want to use. Then create a new SQL return code class record (or select an existing record) that contains the SQL return code class options you want to use. Make sure that the class name of the SQL return code class record is the same as the value of the SQL Return Code Class Name option.

To create an SQL return code class record

Note

For details about this task, see Reference.

  1. Access the APPLICATION RESTART Control primary menu, and select option 13 (SQL return code options).
  2. On the List Records panel, enter the ADD command.
  3. On the Add Record panel, enter the name of the SQL return code class you want to define.
  4. For each option field on the SQL Return Code Class Options panel, type the values you want to use.Field-level help with ? is not available on these panels.

  5. Press Enter to validate the information.

    Tip

    Enter the END command to save the record and exit from the panel.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*