Handling SQL codes with EXECSQL

With EXECSQL, any responses that you define override the product’s default SQL code handling responses.

To define an SQL code response with EXECSQL, specify the following items:

  • Statement type
  • Condition
  • Response

Related topic

SQL-code-handling-during-SQL-execution

For example, an SQL code response could specify a statement type of insert, a condition of -803, and a response of abort.

This section contains the following topics:

 

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