Re: column length (collength)

Posted in 2013

FRANK — Mon, 28 Jan 2013 17:03:47 -0500 — source: Usenet: comp.databases.informix

Just make sure. I have a column defined as, ingest_dt datetime year to second not null ; Its info in syscolumns shows, colname ingest_dt tabid 267 colno 7 coltype 266 collength 3594 colmin colmax extended_id 0 seclabelid 0 colattr 0 So, physically, the ingest_dt column might occupy 3594 bytes in disk for a row? I doubt this. Thanks, Frank On Sat, Jan 26, 2013 at 6:35 PM, Art Kagel <art.kagel@gmail.com> wrote: > The values for the parts of the qualifiers are found in the header file > datetime.h in $INFORMIXDIR/incl/esql along with macros to extract the > values. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > > On Thu, Jan 24, 2013 at 7:35 AM, <tomcaml@gmail.com> wrote: > >> Thank you much >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >