DSNH4772I I csect-name LINE line-number COL column-number UNQUALIFIED IDENTIFIER identifier-name IS USED IN AN AMBIGUOUS CONTEXT

Explanation

The identifier that is indicated by identifier-name is not a unique reference in the SQL statement context.

csect-name
The name of the control section that issued the message.
line-number and column-number
The location of the error in the source program.
identifier-name
The non-unique identifier. An sql-parameter or sql-variable with the same name is declared, but it does not have priority over a column with this name in this context.

System action

Processing continues.

User response

Inspect the ambiguous reference, and qualify the named identifier to clarify the intended usage in the SQL statement.

  • For a reference to an SQL parameter, qualify the name with the SQL PL routine name.
  • For a reference to an SQL variable, qualify the name with the label of the compound statement that declares the variable. If no label is present in the compound statement, add one.
  • For a reference to a column, qualify the name with the appropriate table designator.

Severity

0 (informational)