1. User's Guide
  2. Oracle DB2 Data Dictionary Views

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.