Page 1 of 1

Usage of LONGVAR datatype in DB2.

Posted: Wed Dec 23, 2015 2:05 pm
by rokishU
Hi,

I recently read about the LONGVAR data type in DB2. I searched and looked about in the books in libraries to find some information about this data type. But most of the difintion suggest that this variable is character length and can have a length greater that 256. This is pretty much like the VARCHAR then how's it different than VARCHAR? Can it be used in COBOL programming while writing a COBOL DB2 program?

Thanks for your help on this.

Re: Usage of LONGVAR datatype in DB2.

Posted: Fri Dec 25, 2015 3:24 am
by Akatsukami
I believe that it is obsolete and has been replaced by LOBs. Moreover, VARCHAR has a maximum length of 32,704 in DB2 V11.0.

Re: Usage of LONGVAR datatype in DB2.

Posted: Tue Feb 09, 2016 10:52 am
by rokishU
Thanks Akatsukami!