Re: AW: Another Question about variable length fields

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Ah - this explains the optimization I'm seeing with a short VARCHAR - 
thanks. This makes sense from what I remember when digging into this - 
the amount of space to accommodate short VARCHARs would be better used 
for the actual data.

Vern

Birgitta Hauser wrote:
> Hi,
>   
-snip-
> Internally, DB2 UDB for iSeries will automatically set the Allocate value to
> the maximum length of the variable length column whenever the column length
> is 30 bytes or less.
-snip-