Skip to Content

Intercept SQL return codes

The Intercept SQL Return Codes option controls whether 

AR/CTL

 attempts to intercept a defined SQL return code and transform it to a defined user abend code and reason code. This defined user abend code and reason code can be defined as a combination that is eligible for application reattach processing.

SQL return code handling requires the use of an SQL return code class record. You can use an existing record or create a new one. For more information, see Setting-SQL-return-code-class-options.

Panel field

Intercept SQL return codes

Keyword

SQLRC

Values

Set one of the following values:

  • N
    Do not intercept SQL return codes.
  • Y
    Intercept defined SQL return codes and transform them according to the definitions in the selected SQL return code class record. You must set the SQL Return Code Class Name option to the name of the SQL return code class record you want to select.

Default

N

Related topic

Using-the-DB2-Options-panel

 

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

BMC AMI Application Restart Control for Db2, IMS and VSAM 4.2