-461   A VALUE WITH DATA TYPE source-data-type CANNOT BE CAST TO TYPE target-data-type

Explanation

The statement contains an implicit or explicit CAST, but the combination of the source and target data types is not supported. DB2® attempted to cast a value of source-data-type to the data type target-data-type. This combination is not supported.

System action

The statement cannot be processed.

Programmer response

Change the data type of either the source or target so that the cast is supported.

For built-in data type values, or a cast involving a user-defined distinct type value, see Casting between data types.

If an explicit CAST was specified, correct the CAST specification to specify a supported combination of source and target types.

SQLSTATE

42846