I have a field in Table which is a data type of "VARCHAR 1000" but we can't insert anything more than 255 characters. So, does any one know what is up with this?

Our Database is running on DB2 (v6.5) on OS/390.

Thanks
bjmp

Hi.

I think that is way beyond the limit of the varchar datatype. Am not sure but I think the limit is 256 would be advisable to use a CLOB or a LOB for that.

That's the way we've implemented it at our end.


Nitin.