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.
Usage of LONGVAR datatype in DB2.
-
Akatsukami
- Global Moderator
- Posts: 122
- Joined: Tue Oct 20, 2015 3:20 am
- Location: Bloomington, IL
- Contact:
Re: Usage of LONGVAR datatype in DB2.
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.
"I come to the conclusion that, men loving according to their own will and fearing according to that of the prince, a wise prince should establish himself on that which is in his own control and not in that of others." -- Niccolò Machiavelli
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute