Hitachi

Hitachi Advanced Database Messages


KFAA31137-E

There is an error in the specified syntax format. (reason = aa....aa) (M+J+O)

There is an error in the specification format of the specified syntax. <SQLSTATE: 425Q2>

aa....aa: Cause of the error
  • TABLE cannot be specified in the derived table of a table function where the ADB_GENERATE_SERIES function is specified

    TABLE cannot be specified for a table function derived table that specifies the ADB_GENERATE_SERIES function.

S:

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

Action:

The table function derived table that specifies the ADB_GENERATE_SERIES function is specified in the format TABLE(ADB_GENERATE_SERIES-function). Correct it as follows:

Incorrect:

FROM TABLE(ADB_GENERATE_SERIES(...))

Correct:

FROM ADB_GENERATE_SERIES(...)