| |
- Causa
- A STRING CANNOT BE USED BECAUSE IT CANNOT BE TRANSLATED. REASON reason-code, CHARACTER code-point, HOST VARIABLE
position-number
A translation error occurred during the translation of a string to a different coded character set. 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 Translate 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 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.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Take one of the following actions based on the reason-code.
- 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
translated.
- If the reason-code is 12, either change the translate table to accept the code-point or the data to eliminate the
code-point.
- 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.
- If the reason-code is 20, correct the translate procedure.
- If the reason-code is 24, delete the SBCS character from the graphic string.
SQLSTATE: 22021
© Copyright IBM Corp.
|
| |
