Data Warehousing Community Forum Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
 
Home Help Search Login Register
*
Welcome, Guest. Please login or register.
Did you miss your activation email? 		September 09, 2010, 06:32:32 am


Login with username, password and session length


Data Warehousing Community Forum > Databases > IBM DB2 > Topic: System tables/views in DB2
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: System tables/views in DB2  (Read 510 times)
Allegra
DW Apprentice
**

Reputation: +14/-0
Offline Offline

Posts: 53



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: 114


Forum Don


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
You don't get it.  I built this place. Down here, I make the rules. Down here, I make the threats. Down here, I'm God.
Pages: [1]   Go Up
  Print  
Data Warehousing Community Forum > Databases > IBM DB2 > Topic: System tables/views in DB2
 « previous next »
 
Jump to:  



© Copyright 2006-2010 DW Forum. All rights reserved

contactSanghala | Cyber Militia | Powered by SMF | SMF © 2006-2009, Simple Machines LLC | Dilber MC Theme by HarzeM