Re: column length (collength)
No. The collength value includes the starting and ending precision of the datetime encoded in it as well as the length. LENGTH = collength >> 8 StartPrec = (collength >>4) mod 16 EndPrec = (collength mod 16 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 Mon, Jan 28, 2013 at 5:03 PM, FRANK <yunyaoqu@gmail.com> wrote: > 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 >> >> >