In this post, you’ll learn about the error message -102 the length of the string constant beginning string is>250 characters or 124 graphic characters in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-102 the length of the string constant beginning string is>250 characters or 124 graphic characters
Reason for the Error
The string constant beginning with ‘string’ has a length greater than 254 characters or 124 graphic characters.� Character strings with lengths greater than 254 and graphic strings with lengths greater than 124 can be specified only through assignment from host variables.
Solution
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.
