DB2Connection.typeMaxVarChar=254??

[Freddy]

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

[Jan M. Nelken]

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