SQL code handling during SQL execution

BMC AMI Log Master validates any SQL updates that it performs as it executes SQL statements.

In addition, the product examines the SQL codes that Db2 returns and takes appropriate action based on your specifications.

Related topic

Running-SQL


Important

The High-speed Apply Engine distributed with BMC AMI Log Master does not alter how Db2 generates SQL codes or responds to them; it alters only how High-speed Apply Engine responds to the SQL codes.

For example, if a user is not authorized to update a table and attempts to do so, Db2 will not update the table and will generate SQL code -551. High-speed Apply Engine does not override this condition, even if your code handling rules specify IGNORE for the -551 code. (In this example, Db2 does not update the table, but High-speed Apply does not report the failure).

The following table summarizes SQL code handling for each of the product’s general methods for executing SQL. 

SQL execution method

Online interface

Batch interface

References

EXECSQL

This method enables a limited subset of High-speed Apply Engine responses to SQL codes.

SQL Execution Codes Handler Maintenance panel

Insert an SQLCODES DD statement directly in your JCL.

Generated High-speed Apply Engine JCL

This method enables more High-speed Apply Engine responses than the EXECSQL method but does not enable all High-speed Apply Engine responses to SQL codes.

Main Menu option Generate High-speed Apply JCL

Not available

Independently coded High-speed Apply Engine JCL

This method enables all High-speed Apply Engine responses to SQL codes.

Not available

Code a separate job or job step that explicitly runs High-speed Apply Engine. Specify configuration parameters in a separate configuration file or in-stream in your JCL.

This section contains the following topics:

 

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