Hitachi

Hitachi Advanced Database Messages


KFAA31132-E

NULL can be specified as the selection expression of a SELECT statement only in the outermost query excluding WITH clauses and provided that the query is not the target of set operators. (M+J+O)

Although NULL is specified in the selection expression in a query specification, an error occurred in the SELECT statement because the following conditions are not met. <SQLSTATE: 425CM>

  • NULL can be specified only in the selection expression for the outermost query specification in the SELECT statement.

  • NULL cannot be specified in the selection expression for a query specification that is the target of the set operation.

  • NULL cannot be specified in the selection expression for a query specification in the WITH clause.

S:

Ignores this SQL statement.

Action:

Correct the SQL statement.