I tried many queries like using this
SELECT TABNAME,COLNAME from SYSCAT.COLUMNS where TABNAME='DETAILS'
Also used user_tabs
in place of SYSCAT.COLUMNS
as well, but it does not work in informix.
I tried many queries like using this
SELECT TABNAME,COLNAME from SYSCAT.COLUMNS where TABNAME='DETAILS'
Also used user_tabs
in place of SYSCAT.COLUMNS
as well, but it does not work in informix.
Informix does not install the Information Schema tables necessary to support your query; indeed it does not use the schema name ('owner' in Informix parlance) of SYSCAT
when it does have (the very old version of) the Information Schema installed.
There's a file $INFORMIXDIR/etc/xpg4_is.sql
that you can run for a given database that will install tables informix.TABLES
and informix.COLUMNS
but not a table user_tabs
.