Hitachi

Hitachi Advanced Database Messages


KFAA31226-E

The scalar function "LTDECODE" is specified incorrectly. (reason = aa....aa, query number = bb....bb) (M+J+O)

The specified scalar function LTDECODE contains an error. <SQLSTATE: 4278S>

aa....aa: Cause of the error
  • a dynamic parameter by itself cannot be specified for all of the target data and comparison data

    Parameters cannot be specified so that all of the following conditions are satisfied.

    • Only a single dynamic parameter is specified for the target data.

    • Only a single dynamic parameter is specified for all of the comparison data.

  • a dynamic parameter by itself or NULL cannot be specified for all of the return value and predefined return value

    Parameters cannot be specified so that all of the following conditions are satisfied.

    • Only a single dynamic parameter is specified for all of the return values, or NULL is specified.

    • Only a single dynamic parameter is specified for the predefined return value, or NULL is specified.

bb....bb: Query position number

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.