Re: Length of long datatypes

jim nash wrote:
>
> How does one determine the storage used by long datatypes?
>
> Specifically, I need something like 'max(vsize(long_data))' for a
> given table, for use in determining IMP <buffersize>, but vsize
> cannot be used with longs.

Probably not what you had in mind, but you could write a Pro*C program to select all the LONGs and keep track of the sizes to report the info you want. I use Pro*C a lot to manipulate LONG column data.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trw_at_medicalert.org || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||