Previous Topic Next topic Print topic

Micro Focus Studio Enterprise Edition for Windows > Programming > Mainframe Programming > HCO for SQL Server (HCOSS) > Reference > Required DB2 Catalog Tables

Required DB2 Catalog Tables

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

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
Parent topic: Reference
Related concepts
Extract Schema Tool
Related tasks
To create a DB2 connection
To extract DB2 schemas
Previous Topic Next topic Print topic