Micro Focus Enterprise Developer 2.3 Update 2 for Eclipse > Programming > Mainframe Programming > HCO for SQL Server (HCOSS) > Reference > Required DB2 Catalog Tables

Required DB2 Catalog Tables

Restriction: This topic applies to Windows environments only.

The login credentials used to connect to the mainframe DB2 database must grant read access to the following DB2 system catalog tables:

Note: In addition to these DB2 Catalog table permissions, the Microsoft OLE DB provider must be properly configured with mainframe DB2. Please see DB2 Database Migration Process for additional information.

Object Type	DB2 System Catalog Table
tables, columns	SYSTABLES, SYSCOLUMNS, SYSSEQUENCES
indexes	SYSINDEXES, SYSKEYS
constraints (relational, check, key)	SYSCHECKS, SYSCHECKDEP, SYSCHECKS2, SYSCONSTDEP, SYSTABCONST, SYSKEYCOLUSE, SYSRELS, SYSFOREIGNKEYS
views	SYSVIEWS, SYSVIEWDEPENDENCY