John,
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
record?
TIA,
jte
--
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
+---
