DSNH587I A list of item-references are not in the same family.

Explanation

Each item-reference in the SET assignment statement is either a host-variable or a transition-variable. The list of item-references must be of the same family, meaning if one of the item-references is a transition-variable, then all of the item-references in the list must be a transition-variable. If the statement is used in the triggered action of a CREATE TRIGGER statement, each item-reference must identify a transition variable. If the statement is used in any other context, each item-reference must identify a host variable.

System action

The corresponding SQL statement is replaced by host language statements that will, if executed, set an error code in the SQLCA.

User response

Correct the syntax of the SQL statement and precompile the program again. Refer to the Db2 SQL Reference to information on the SET assignment statement.

Programmer response

Correct the statement and execute it again.

Severity

8 (error)