Re: Another Question about variable length fields

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Hi James

I seem to remember that the auxiliary space for variable-length data 
that exceeds the allocation is not reused. So even if you update a VL 
field with a shorter value but still greater than allocation, it uses 
more of the auxiliary area. If you reduce it to less than allocation, 
then it returns to the main area, yet the auxiliary area is not cleared 
of the old data. Now this was in 2001 or so, and I don't remember 
anymore how to walk through SST to see the auxiliary area. Anyone have 
the magic locations?

CPYF did not seem to clear it, either - only RGZPFM.

Vern

James H. H. Lampert wrote:
> John Allen wrote:
>
>   
> > I then updated the file so that the new file with the new variable length
> > field has data truncated to minimum length (stripped off trailing blanks)
> >     
>
> Just for grins, try a RGZPFM on it. The space you squeezed out of the 
> records may still be inflating the heap size.
>
> --
> JHHL
>