Hitachi

Hitachi Advanced Database Messages


KFAA31740-E

The data included in the column "aa....aa" derived from the result of the outermost query in the query expression body of the COPY statement is invalid. (reason = bb....bb) (M+J+O)

The data contained in the column "aa....aa" derived by the outermost query specification in the query expression body of the COPY statement is invalid. <SQLSTATE:5100P>

aa....aa:

Column name or its field name

bb....bb: Cause of the error
  • The data exceeds the range of values that can be handled by the TIMESTAMP column type.

    The data exceeds the range of values that can be handled by the TIMESTAMP column type.

S:

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

Action:

Take one of the following corrective actions, and then re-execute the SQL statement.

  • Ensure that the data in the derived column are within the range of the TIMESTAMP column type.

  • Change the data type of the derived column.

For data that can be handled by the COPY statement, see COPY (output search results to a file) in the HADB SQL Reference manual.