DB2 Error -102

[BlueCrossChris]

I am receiving the following error:

SQL Code -102
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

The 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.

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.

[vssp]

according to the error message manual:

ORA-01704 string literal too long
Cause: The string literal is longer than 4000 characters.
Action: Use a string literal of at most 4000 characters. Longer values may
only be entered using bind variables.

make sure you get yourself a copy for future reference ;-)