Hitachi

Hitachi Advanced Database Messages


KFAA31239-E

The specification of the table function column list is invalid. (reason = aa....aa, query number = bb....bb) (M+J+O)

The table function column list specified in the table function derived table is invalid. <SQLSTATE: 427JA>

aa....aa: Cause of the error
  • the table function column list cannot be specified for the system-defined function "ADB_AUDITREAD"

    If the ADB_AUDITREAD function is specified in the table function derived table, the table function column list cannot be specified.

  • the table function column list is not specified for the system-defined function "ADB_CSVREAD"

    If the ADB_CSVREAD function is specified in the table function derived table, the table function column list must be specified.

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