Hitachi

Hitachi Advanced Database Messages


KFAA31228-E

The specification method of the scalar function "TIMEZONE" is invalid. (reason = aa....aa, query number = bb....bb) (M+J+O)

The specified scalar function TIMEZONE is invalid. <SQLSTATE: 4278V>

aa....aa: Cause of the error
  • the length of the time zone string exceeds 100 bytes

    The length of the time zone string exceeds 100 bytes.

  • the total number of TIMEZONE scalar functions specified in the SQL statement exceeds 1,000

    The number of TIMEZONE scalar functions specified in a single SQL statement exceeds the limit of 1,000.

bb....bb: Query position number

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

If the query position number cannot be output, *** is displayed.

S:

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

Action:

Correct the SQL statement.