Skip to Content

Default language.

Condition

The condition indicates the type of returned SQL code that triggers a given BMC AMI Log Master response.

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

Related topic

Handling-SQL-codes-with-EXECSQL

Condition values for SQL code handling

SQL code value

BMC AMI 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.

 

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

BMC AMI Log Master for Db2 13.1