i tried many queries using
select tabname,colname syscat.columns tabname='details'
also used user_tabs
in place of syscat.columns
well, not work in informix.
informix not install information schema tables necessary support query; indeed not use schema name ('owner' in informix parlance) of syscat
when have (the old version of) information schema installed.
there's file $informixdir/etc/xpg4_is.sql
can run given database install tables informix.tables
, informix.columns
not table user_tabs
.
Comments
Post a Comment