RE: syscolnames
You mean like this one?
#!/bin/ksh
# Findcol. JP 1992.
DBNAME=$1
CNAME=$2
set -- `dbaccess $DBNAME - <<! 2>/dev/null
output to /dev/tty
select tabname, colname, coltype, collength from syscolumns, systables
where colname matches '$CNAME'
and syscolumns.tabid =systables.tabid
order by tabname!`
Alas - this one is database specfic.
> -----Original Message-----
> From: mrhodes [mailto:mrhodes@rez.com]
> Sent: Wednesday, November 15, 2000 12:25 PM
> To: informix-list@iiug.org
> Subject: syscolnames
>
>
> Does anyone know what the tabid in the syscolnames ties to?
>
> colname disc_flg
> tabid 386
> colno 9
> coltype 0
> collength 1
> colmin
> colmax
>
>
> I thought it would tie to sysmaster:systabnames but it only
> has a partnum
> that does not match.
>
> I am trying to write an sql that would allow me to search for
> the table that
> a particular column is in.
>
> MDR
>
>