RE: Finding row size of a query

This might not be the version you want, but you could investigate DBD-informix: http://search.cpan.org/~johnl/DBD-Informix-2008.0229/Informix.pm You might be able to do everything in perl. > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of dcruncher4@aim.com > Sent: Friday, March 07, 2008 9:41 AM > To: informix-list@iiug.org > Subject: Finding row size of a query > > > Informix 7.31 > Informix-ESQL Version 9.53.UC3XJ > > I am writing a tool which will calculate the disk space required to > download the data from a table or a query, in binary form via > onpload. > The data download can be a simple select * from table or complex join, > or can be a view. > > 1. How do I find out what will be the size of the row of the query. > The only way I am aware of is using ESQL/C DESCRIBE. Is there a > simpler way. > > 2. I would really like to avoid writing the tool in ESQL/C since very > few in our group, besides me, know ESQL/C. Is there a generic way > of finding the row size of a query so that I can write the tool in > perl, my preferred language. > > TIA. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**