as400 system table with user table information?

[k***@gmail.com]

Is there a system table on the as400 that is usable by SQL to see what
tables exist in the database?

Oracle has something called user_tab_columns for the fields and tables
in the database, I'd like to find the as400 equivalent.

Thanks!

[Karl Hanson]

Post by k***@gmail.com
Is there a system table on the as400 that is usable by SQL to see what
tables exist in the database?
Oracle has something called user_tab_columns for the fields and tables
in the database, I'd like to find the as400 equivalent.

See SYSTABLES and SYSCOLUMNS catalogs:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstcatalogtbls.htm
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstcatalog.htm

--
Karl Hanson

[DBDriver]

Post by Karl Hanson

Post by k***@gmail.com
Is there a system table on the as400 that is usable by SQL to see what
tables exist in the database?
Oracle has something called user_tab_columns for the fields and tables
in the database, I'd like to find the as400 equivalent.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstcatalogtbls.htm
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstcatalog.htm
--
Karl Hanson

As a digression, DB2-UDB use "SYSCAT." catalog instead of "SYSIBM.". It
appears the focus in the UDB world is SYSCAT.

Does anyone know if there are moves to make a consistent convention across
the various DB2 versions?

Rj.