• Subject: Re: Variable Length fields
  • From: "David Morris" <dmorris@xxxxxxxxxxxxx>
  • Date: Wed, 05 Apr 2000 17:51:25 -0600


You can specify the space to allocate.  For SQL you specify:

field varchar(32767) allocate(200) etc.

For DDS:

field      32767A    VARLEN(200)

David Morris

>>> johnearl@400security.com 04/05/00 01:50PM >>>
We're wondering how variable length fields are implemented on the
AS/400.  Specifically, it's been guessed that if you create a
variable length field that could be up to 32K in length, will the
OS allocate the entire 32K for every record, or will physical
allocation of disk storage change with each variable length



John Earl                               johnearl@400security.com 
The PowerTech Group                     206-575-0711
PowerLock Network Security              www.400security.com 

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page