Data Warehousing Community Forum
February 08, 2012, 11:11:27 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: System tables/views in DB2  (Read 4932 times)
Allegra
DW Apprentice
**

Reputation: +17/-0
Offline Offline

Posts: 75



View Profile
« 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
Logged
@llegr@
what do you call an Ant with an AK47 ?
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 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
Logged
If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: