sql query for header info along with data in columns in informix -


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