RE: Calculate the Size of unloaded records from a table

Start you data extract. Multiply the sum of the lengths of the columns (when displayed) by the number of rows then add the number of columns multiplied by the number of rows (for delimiters). This will be the maximum size. Then for each varchar, text, integer, decimal or money field work out an average display length and subtract the difference multiplied by the number of rows. By the time you've finished the data extract will have completed and an ls -al will tell you haw much space has been taken. :-> Keith -> -----Original Message----- -> From: Leo [mailto:buzzleo@gmail.com] -> Sent: Monday, January 23, 2006 9:43 AM -> To: informix-list@iiug.org -> Subject: Calculate the Size of unloaded records from a table -> -> -> Hi, -> -> Is there a short cut way to know what would be the size of a -> flat file, -> which i will be unloading from a informix database table. I need to -> know the space taken by all the tables, if i had to unload them to a -> flat file. -> -> Thanks in advance -> Leo -> -> _______________________________________________ -> Informix-list mailing list -> Informix-list@iiug.org -> http://www.iiug.org/mailman/listinfo/informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************