Freddy wrote:
> DB2 Connect version 7.2 to Mainframe
>
> We have one workstation which through JDBC continues to truncate a
> VARCHAR column at 254 characters.
>
> We've uninstalled and reinstalled DB2 Connect on this workstation.
>
> Going through a debugger, we can see that
> COM.ibm.db2.jdbc.app.DB2Connection has a field called typeMaxVarChar
> which is set to 254. Great!
>
> But where is this being set? Can't seem to find this anywhere in the
> documentation, or config files.
>
> Help!
>
> Thanks,
> Freddy
>

You did not specify which version of Db2 of z/OS you are connecting to. From the
SQL Reference for DB2 for z/OS:

A VARCHAR column with a maximum length that is greater than 255 bytes or a CLOB
column of any length is a long string column.

Is your JDBC application using VARCHAR data type (SQL Type 448) or LONG VARCHAR
data type (SQL type 456)?

Jan M. Nelken