DB2 datatypes

[sbhav]

Hello all,
I want to store an object output stream which is converted in to byte array in DB2 version 6.0. My database has a column called VALUE of Datatype varchar2 of length 3200. I am having a problem here. Because I want to store an object in the form of byte array and the type is varchar. It is exceeding the length specified in the database. Even if the data is written in to the database, if the length is lesser than 3200. I am having problem while reading from the databse. Is there a datatype in DB2 which fits in this kind scenario.

Thanks
Ramak

 

[blom0344]

How about BLOB or DBLOB? I think that more recent versions of DB2 have more space available in the varchar data type, at least 4000 positions.......... T. Blom
Information analyst
tbl@shimano-eu.com