| |
- Causa
- LITERAL STRING IS TOO LONG. STRING BEGINS string
The string constant beginning with 'string' has a length greater than 255 characters or 124 graphic characters.
Character strings with lengths greater than 255 and graphic strings with lengths greater than 124 can be specified only through assignment from
host variables.
For special registers, the allowable length depends on the particular special register.
See Chapter 3 of the SQL Reference to determine the maximum length of a value for a special register.
Two consecutive string delimiters are used to represent one string delimiter within the character string, but these count as 2 bytes when
calculating the lengths of character string constants.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- The requested function is not available interactively.
If the error occurred in the context of an SQL statement embedded in an application program, the desired result can be achieved by assigning the
long string to a host variable, and substituting that variable for the string literal in the SQL statement.
SQLSTATE: 54002
© Copyright IBM Corp.
|
| |
