MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2000

Re: Variable Length fields


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

fixed

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
+---





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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact