RE: column number in syscolumns table
Posted in 2004
Topics: General Discussion
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> <P><FONT SIZE=2>Or he could just look it up in the </FONT> <BR><FONT SIZE=2>IBM Informix Guide to SQL (RTFM). It's all</FONT> <BR><FONT SIZE=2>explained there.</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Bill Dare [<A HREF="mailto:dareb@jevic.com">mailto:dareb@jevic.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Tuesday, February 03, 2004 1:42 PM</FONT> <BR><FONT SIZE=2>To: 'tomcaml@yahoo.com'; informix-list@iiug.org</FONT> <BR><FONT SIZE=2>Subject: RE: column number in syscolumns table</FONT> </P> <BR> <P><FONT SIZE=2>This is not stored in a table. It must be derived. I have an C program I</FONT> <BR><FONT SIZE=2>can send you to print the type/precision of a column given</FONT> <BR><FONT SIZE=2>syscolumns.coltype and syscolumns.collength.</FONT> </P> <P><FONT SIZE=2>Regards,</FONT> <BR><FONT SIZE=2>Bill</FONT> </P> <P><FONT SIZE=2>> -----Original Message-----</FONT> <BR><FONT SIZE=2>> From: tomcaml@yahoo.com [SMTP:tomcaml@yahoo.com]</FONT> <BR><FONT SIZE=2>> Sent: Tuesday, February 03, 2004 10:42 AM</FONT> <BR><FONT SIZE=2>> To: informix-list@iiug.org</FONT> <BR><FONT SIZE=2>> Subject: column number in syscolumns table</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> greetings</FONT> <BR><FONT SIZE=2>> if i have a tabname from systables (say it's tabid is 150 and it's</FONT> <BR><FONT SIZE=2>> tabname is stakeholder) and i go look up tabid of 150 in the</FONT> <BR><FONT SIZE=2>> syscolumns table, there is also a field in syscolumns called Colno -</FONT> <BR><FONT SIZE=2>> how do i get the datatype that is represented by this Colno in another</FONT> <BR><FONT SIZE=2>> system table (i am assuming there is one that will tell me this) ?</FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> thanks,Tom</FONT> <BR><FONT SIZE=2>sending to informix-list</FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01C3EA8A.424D6260-- sending to informix-list