Start of change

DSNH4792I csect-name LINE line-number COL column-number SQL STATEMENT WILL CAUSE AN ERROR IN BIND, REASON reason-code

Explanation

An SQL statement that uses invalid syntax was detected by the precompiler or Db2 coprocessor. This message does not terminate the compile, but binding the DBRM produced by this compile may result in an error.

csect-name
The name of the control section that issued the message.
line-number
The line number of the invalid SQL syntax.
column-number
The column number of the invalid SQL syntax
reason-code
  1. A SELECT INTO statement contains a UNION or UNION ALL set operator.

System action

The invalid SQL is allowed in the compile.

User response

Plan to revise the SQL statement to remove the invalid syntax.

Severity

4 (warning)

End of change