Re: File size with varlen fields

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

 Alan

I had to look up VARLEN - if you leave off the allocated length, then it 
is set to 0 and all the data goes in the auxiliary space. In that case, 
it all depends on how Albert put the data into the field. And in RPG it 
is too easy to get bit by setting a varying field to the value of a 
fixed-length field

Vern

On 9/14/2010 6:17 PM, Alan Campin wrote:
> Because you defined each record to 32000 bytes. When you specify Varlen you
> can also tell it how much storage to allocate in the record and how much to
> allocate to overflow. You just defined it as 32000 bytes which means every
> record takes 32000 bytes.
>
> On Tue, Sep 14, 2010 at 5:03 PM, Albert York<alfromme@xxxxxxxxx>  wrote:
>
> > I have a very long field (32000 bytes) that I defined in a file using
> > varlen. Most of the time the field will be around 1 K but sometimes it
> > could be 32000 bytes.
> >
> > When I look at the file size it shows 1.357 GB for 44180 records. When
> > I look at the records the field size for that field looks correct.
> >
> > Why is the file so large?
> >
> > Thanks,
> >
> > Albert
> > --
> > This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.