SQL Code -102The string that I am trying to insert is 600 bytes long. The column on my DB2 table is physically a combination of columns that equal 600 bytes - but logically is a single 600 byte column.
LITERAL STRING IS TOO LONG. STRING BEGINS string
Explanation: 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.
System Action: The statement cannot be executed.
Programmer Response: 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
On the mainframe side of our application, we are able to insert, select, etc to this column without any problems, but I can't get the application to insert on the web side.
Any suggestions? A co-worker suggested using host variables, but I cannot find how to do this in java.