DB2 SQL-Error: -20232
SQLState: 57017
Short Description: CHARACTER CONVERSION FROM CCSID TO FAILED WITH ERROR CODE FOR TABLE COLUMN REQUESTED BY
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: v 8 - Length exception (for example, expansion required for PC MIXED data exceeds the maximum length of the string). v 20 - Translate 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). v 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, refer to the section entitled ?Character conversion? of DB2 Installation Guide for information on how to add conversion support. For all the other error-codes, refer to Part 2 of DB2 Diagnosis Guide and Reference for information on identifying and reporting the problem.