Hitachi

Hitachi Advanced Database Messages


KFAA31240-E

The specification of the table function derived table that includes the system-defined function "aa....aa" is invalid. (reason = bb....bb, detail = cc....cc, query number = dd....dd) (M)

The specification of the table function derived table with the system-defined function aa....aa specified is invalid.

aa....aa:

System-defined function name

bb....bb: Cause of the error
  • specified position: The specified position is invalid. <SQLSTATE: 427K0>

cc....cc: Details about the error
  • the table cannot be specified in correlated subqueries: The table function derived table cannot be specified in a subquery that includes an external reference column.

  • the table cannot be specified in a multiset value expression: The table function derived table cannot be specified in a multiset value expression.

dd....dd: Position number of the query that specified the table function derived table

For details about query position numbers, see 1.5 Query position numbers.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.