RE: column number in syscolumns table

Posted in 2004

Bill Dare — Tue, 3 Feb 2004 13:42:02 -0500 — source: Usenet: comp.databases.informix

This is not stored in a table. It must be derived. I have an C program I can send you to print the type/precision of a column given syscolumns.coltype and syscolumns.collength. Regards, Bill > -----Original Message----- > From: tomcaml@yahoo.com [SMTP:tomcaml@yahoo.com] > Sent: Tuesday, February 03, 2004 10:42 AM > To: informix-list@iiug.org > Subject: column number in syscolumns table > > greetings > if i have a tabname from systables (say it's tabid is 150 and it's > tabname is stakeholder) and i go look up tabid of 150 in the > syscolumns table, there is also a field in syscolumns called Colno - > how do i get the datatype that is represented by this Colno in another > system table (i am assuming there is one that will tell me this) ? > > thanks,Tom sending to informix-list