Re: Anyone have a function to compute the size of a column?

In article <1995May23.231123.16763@lmpsbbs.comm.mot.com> ennis@rastov10.comm.mot.com "Bill Ennis" writes: > Hi, > > I am working on an application which estimates the size a > table will take. It looks at the data and index space for > a table and therefore needs individual column sizes. This > is easy for columns which are integers, character strings, > etc since you can just query collength from syscolumns. > However, it's not so easy for columns which are datetime > since collength does not store the size dierctly. I have > located the information needed to do this in the SQL guide > but am looking to see if someone has already done this since > it would be a tedious function to write. > > Thanks in advance. > Bill Hello Bill, Some, not all, of what you want can be found in the 4GL by example manual. There should be enough to get you started. The source code is also supplied, it is in $INFORMIXDIR/demo/fglbe/ex30.4gl. If you do not have it let me know and I'll mail it to you. -- -------------------------------------------------------------------------- paul sellars,humberside,u.k. ==========================================================================