SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 02:49 AM
| ||||
| ||||
 DB2Connection.typeMaxVarChar=254?? 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      |
|
02-27-2008, 02:49 AM
| ||||
| ||||
| Re: DB2Connection.typeMaxVarChar=254?? 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 |
Linear Mode
