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