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.