DB2 SQL-Error: -330
SQLState: 22021
Short Description: A STRING CANNOT BE USED BECAUSE IT CANNOT BE PROCESSED REASON CHARACTER HOST VARIABLE
AN error occurred during the processing of a string, or in the conversion of a string. The type of error is indicated by the reason-code: 8 Length exception (for example, expansion required for PC MIXED data exceeds the maximum length of the string). 12 Invalid code point (for example, use of the ERRORBYTE option of SYSSTRINGS). 16 Form exception (for example, invalid MIXED data). 20 Conversion procedure error (for example, an exit set the length control field of the string to an invalid value). 24 SBCS character found in string contained in a wchar_t or sqldbchar host variable.If the reason-code is 12, code-point is the invalid code point. Otherwise, code-point is either blank or an additional reason-code returned by an exit. If the string is the value of an input host variable, the position-number is the ordinality of the variable in the SQLDA. If the string is not the value of a host variable, the position-number is blank. System action: The statement cannot be executed. Programmer response: Take one of the following actions based on the reason-code v If the reason-code is 8, extend the maximum length of the host variable to allow for the expansion that occurs when the string is converted. v If the reason-code is 12, either change the convert table to accept the code-point or the data to eliminate the code-point. v If the reason-code is 16 and the string is described as MIXED data, either change its description or the string to conform to the rules for well-formed mixed data. v If the reason-code is 20, correct the conversion procedure. v If the reason-code is 24, delete the SBCS character from the graphic string.