Hitachi

Hitachi Advanced Database Messages


KFAA30326-E

The length or precision of the data entered for a dynamic parameter (item aaaa) is invalid. (M+J+O)

The data that was input for the dynamic parameter has one of the following errors.

  • If the input data is a fixed-point number represented as decimal data, the number of decimal digits specified does not match the precision. <SQLSTATE: 22003>

  • If the input data is floating-point numeric data, the input data is NaN (not a numeric) or infinity. <SQLSTATE: 22003>

  • If the input data is datetime data, the data format is invalid, or the specified datetime does not exist. <SQLSTATE: 22007>

  • If the input data is fixed-length character string data, its length is invalid. <SQLSTATE: 22505>

  • If the input data is variable-length character string data or variable-length binary data, the length of the input data exceeds the maximum or is less than 0. <SQLSTATE: 22505>

  • The input data's indicator value is invalid. <SQLSTATE: 22521>

aaaa:

The order number of the invalid input data

S:

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

Action:

Correct the input data or its indicator value.

Specify values for the data type and data length that are valid for the dynamic parameters assumed to be in the input data. For details about the data types and data lengths that are valid for dynamic parameters, see Variables (dynamic parameters) in the manual HADB SQL Reference.

For details about the data formats of input data, see Data Types in the manual HADB SQL Reference.

For details about the indicator values, see a_rdb_SQLInd_t (indicator) in the HADB Application Development Guide.