A Oracle DB2 Data Dictionary Views
These topics cover the Oracle Database Gateway for DRDA data dictionary views that are supported by the gateway for DB2 UDB for z/OS, DB2 UDB for iSeries, and DB2/UDB DRDA servers.
Any user with SELECT
privileges for DB2 catalog tables can access most of the views.
N/A is used in the tables to denote that the column is not valid for the gateway.
- ALL_CATALOG
ALL_CATALOG
data dictionary for Oracle Database Gateway for DRDA. - ALL_COL_COMMENTS
ALL_COL_COMMENTS
data dictionary for Oracle Database Gateway for DRDA. - ALL_CONS_COLUMNS
ALL_CONS_COLUMNS
data dictionary for Oracle Database Gateway for DRDA. - ALL_CONSTRAINTS
ALL_CONSTRAINTS
data dictionary for Oracle Database Gateway for DRDA. - ALL_INDEXES
ALL_INDEXES
data dictionary for Oracle Database Gateway for DRDA. - ALL_IND_COLUMNS
ALL_IND_COLUMNS
data dictionary for Oracle Database Gateway for DRDA. - ALL_OBJECTS
ALL_OBJECTS
data dictionary for Oracle Database Gateway for DRDA. - ALL_SYNONYMS
ALL_SYNONYMS
data dictionary for Oracle Database Gateway for DRDA. - ALL_TABLES
ALL_TABLES
data dictionary for Oracle Database Gateway for DRDA. - ALL_TAB_COLUMNS
ALL_TAB_COLUMNS
data dictionary for Oracle Database Gateway for DRDA. - ALL_TAB_COMMENTS
ALL_TAB_COMMENTS
data dictionary for Oracle Database Gateway for DRDA. - ALL_USERS
ALL_USERS
data dictionary for Oracle Database Gateway for DRDA. - ALL_VIEWS
ALL_VIEWS
data dictionary for Oracle Database Gateway for DRDA. - COLUMN_PRIVILEGES
COLUMN_PRIVILEGES
data dictionary for Oracle Database Gateway for DRDA. - DICTIONARY
DICTIONARY
data dictionary for Oracle Database Gateway for DRDA. - DUAL
DUAL
data dictionary for Oracle Database Gateway for DRDA. - TABLE_PRIVILEGES
TABLE_PRIVILEGES
data dictionary for Oracle Database Gateway for DRDA. - USER_CATALOG
USER_CATALOG
data dictionary for Oracle Database Gateway for DRDA. - USER_COL_COMMENTS
USER_COL_COMMENTS
data dictionary for Oracle Database Gateway for DRDA. - USER_CONS_COLUMNS
USER_CONS_COLUMNS
data dictionary for Oracle Database Gateway for DRDA. - USER_CONSTRAINTS
USER_CONSTRAINTS
data dictionary for Oracle Database Gateway for DRDA. - USER_INDEXES
USER_INDEXES
data dictionary for Oracle Database Gateway for DRDA. - USER_OBJECTS
USER_OBJECTS
data dictionary for Oracle Database Gateway for DRDA. - USER_SYNONYMS
USER_SYNONYMS
data dictionary for Oracle Database Gateway for DRDA. - USER_TABLES
USER_TABLES
data dictionary for Oracle Database Gateway for DRDA. - USER_TAB_COLUMNS
USER_TAB_COLUMNS
data dictionary for Oracle Database Gateway for DRDA. - USER_TAB_COMMENTS
USER_TAB_COMMENTS
data dictionary for Oracle Database Gateway for DRDA. - USER_USERS
USER_USERS
data dictionary for Oracle Database Gateway for DRDA. - USER_VIEWS
USER_VIEWS
data dictionary for Oracle Database Gateway for DRDA.