-20232   CHARACTER CONVERSION FROM CCSID from-ccsid TO to-ccsid FAILED WITH ERROR CODE error-code FOR TABLE dbid.obid COLUMN column-number REQUESTED BY csect-name

Explanation

A conversion error occurred during the conversion of a string to a different coded character set.
from-ccsid
identifies the coded character set of the string to be converted.
to-ccsid
identifies the coded character set to which it must be converted.
error-code
indicates the type of error as defined as follows:
  • 8 - Length exception (for example, expansion required for PC MIXED data exceeds the maximum length of the string).
  • 20 -Conversion procedure error (for example, an error during Unicode/390 stage 2 conversions or an exit set the length control field of the string to an invalid value).
  • 24 - The conversion services have not been setup correctly or the conversion is not supported.
dbid.obid
gives the database id and the table obid of the object with the conversion error. This could be either the target or the source of the conversion.
column-number
gives the column number of the failing object. This could be either the target or the source of the conversion.
csect-name
describes the reason codes returned from DB2®. Reason codes returned from DB2 begin with 'DSN' and identify the context in which the conversion was requested. Values other than those that start DSN' are returned from other DB2 platforms and are described in the documentation for the platform.

System action

The statement cannot be processed.

Programmer response

If the error-code is 24 and the conversion request is correct, you might need to set up character conversion.

If you suspect an error in DB2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.

SQLSTATE

57017