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

Question

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.

Not sure I understand, are you asking about finding schema information? Table names and column names? This old post might help — mconlin
– mconlin, Commented May 6, 2013 at 2:06

Jonathan Leffler · Accepted Answer · 2013-05-06 02:16:29Z

2

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.

answered May 6, 2013 at 2:16

Jonathan Leffler

759k145 gold badges961 silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related