Data Warehousing Community Forum

Databases => IBM DB2 => Topic started by: Allegra on March 29, 2010, 02:39:03 pm

Title: System tables/views in DB2
Post by: Allegra on March 29, 2010, 02:39:03 pm

What are the system tables/views in IBM DB2 ??

In Oracle RDBMS, below are the set of system tables/views..

ALL_TABLES
ALL_TAB_COLUMNS
ALL_PROCEDURES
ALL_ERRORS
ALL_SOURCE

What are the equivalent tables/views in DB2

Title: Re: System tables/views in DB2
Post by: Whoever on March 31, 2010, 08:54:21 pm

ALL_TABLES - SYSIBM.SYSTABLES
ALL_TAB_COLUMNS - SYSIBM.SYSCOLUMNS
ALL_PROCEDURES - SYSIBM.SYSROUTINES, SYSIBM.SYSROUTINESTEXT
ALL_ERRORS - N/A(?)
ALL_SOURCE - SYSIBM.SYSROUTINES, SYSIBM.SYSROUTINESTEXT

For more information, please refer official documentation - http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp