RE: column number in syscolumns table

Posted in 2004

Brian Minnick — Tue, 3 Feb 2004 14:16:43 -0500 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C3EA8A.424D6260 Content-Type: text/plain; charset="iso-8859-1" Or he could just look it up in the IBM Informix Guide to SQL (RTFM). It's all explained there. -----Original Message----- From: Bill Dare [mailto:dareb@jevic.com] Sent: Tuesday, February 03, 2004 1:42 PM To: 'tomcaml@yahoo.com'; informix-list@iiug.org Subject: RE: column number in syscolumns table 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 ------_=_NextPart_001_01C3EA8A.424D6260 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45"> <TITLE>RE: column number in syscolumns table</TITLE> </HEAD> <BODY> Or he could just look it up in the IBM Informix Guide to SQL (RTFM). It's all explained there. -----Original Message----- From: Bill Dare [<A HREF="mailto:dareb@jevic.com">mailto:dareb@jevic.com</A>] Sent: Tuesday, February 03, 2004 1:42 PM To: 'tomcaml@yahoo.com'; informix-list@iiug.org Subject: RE: column number in syscolumns table 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 </BODY> </HTML> ------_=_NextPart_001_01C3EA8A.424D6260-- sending to informix-list

RE: column number in syscolumns table

Related threads

Your privacy choices