Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Log Master for Db2 13.1.

Condition

The condition indicates the type of returned SQL code that triggers a given 

Log Master

 response.

This item corresponds to the High-speed Apply 'Code' configuration parameter. The following table lists the available condition values.

Condition values for SQL code handling

SQL code value

Log Master takes the specified action when Db2 returns

NEGATIVE

Any negative SQL code

POSITIVE

Any positive SQL code

A positive or negative number

The SQL code identified by the number

SQLWARNx

A warning message and the warning number is the same as x. The value of x can be any number from 0 to 9, or the letter A. (Note that 0 means any warning.) Consult the IBM SQLCA documentation for more information.

MULTIPLE

Any SQL code that indicates the executed SQL statement caused the update or deletion of more than one row. In normal execution, the product generates SQL that updates one row per statement.

Related topic

Handling-SQL-codes-with-EXECSQL

 

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

BMC AMI Log Master for Db2 12.1