Charles

I believe that reading just the varying length field always requires 2 IOs if allocated = 0 - there is a location value in the main space that tells data management where in the aux space the data is.

If the data is within the allocated, then there's only one IO, as you said.

Vern

On 7/20/2012 11:53 AM, Charles Wilt wrote:
Barb's right...

But note you're not defining a minimum, the parm to VARLEN defines an
allocated size.

With a default of zero, anything written to the field will be stored
in the table's overflow area. The effect of that is to require 2 disk
I/Os for every access whenever you are touching both the varibale
length field and one or more of the other fields.

In general, when dealing with variable length fields on the IBM i,
it's best to allocate enough space so that 80% or more of your records
fit in the standard record area so that the data will be available
with a single I/O.

HTH,
Charles

On Fri, Jul 20, 2012 at 12:48 PM, Barbara Morris <bmorris@xxxxxxxxxx> wrote:
On 2012/7/20 12:42 PM, Stone, Joel wrote:
I would like to describe a variable length field with a minimum of zero length.

Just remove the parameter from the VARLEN keyword. It defaults to zero.

TEXTDATA 1000 COLHDG('MEMO TEXT')
VARLEN
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.