RE: Size of dbexport
I haven't done it, but you might try selecting the AVG from the numeric
column and using the ascii length of that in your calculation. Not exact,
but probably close enough for government work.
> -----Original Message-----
> From: Sean Galvin [SMTP:sgalvi01@cork.cig.mot.com]
> Sent: Tuesday, January 26, 1999 1:26 PM
> To: informix-list@iiug.org
> Subject: Size of dbexport
>
> At present I am trying to put together a script that accurately works
> out the size of a dbexport.
>
> The problems (fun and games) arrive when you start to work out the size
> of smallints, ints etc. (e.g. binary data).
>
> It's easy enough to work out the max. ascii size of these but this
> provides me with an estimate that is far to high although it is the
> theoretical max. value.
>
> Has any one written a script in the past to do this that they can send
> me.
>
> It would be very much appreciated.
>
> Regards
>
>
>
>
> Sean
>
>
> --
>
> =======================================================
> //////////////// Sean P. Galvin
> ////////// // Senior Consultant
> ////// / /// Informix Software Ltd.
> ///// // ////
> //// // ///// Office: +353 (0) 21 511744
> /// // ////// Home : +353 (0) 21 508265
> // // /////// Mobile: +44 (0) 585 466408
> / /////////// Email : sgalvi01@cork.cig.mot.com
> //////////////// WWW : http://www.informix.com