Enabling SQL return code interception
To enable SQL return code interception, perform the following steps:
- Create or update a processing option record that applies to the application program execution. For more information, see Setting-processing-options.
- 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.
- 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, as described in this section. 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.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*