Hitachi

Hitachi Advanced Database Messages


KFAA30467-E

A table function derived table that includes the system-defined function "aa....aa" cannot be specified in the bb....bb. (query number = cc....cc) (M)

A table function derived table with the system-defined function aa....aa specified cannot be specified in bb....bb. <SQLSTATE: 42849>

aa....aa:

System-defined function name

bb....bb: SQL statement in which the table function derived table is specified
  • DELETE statement: DELETE statement

  • INSERT statement: INSERT statement

  • PURGE CHUNK statement: PURGE CHUNK statement

  • UPDATE statement: UPDATE statement

  • CREATE VIEW statement: CREATE VIEW statement

cc....cc: 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.