Catalog Schema

Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions : Catalog Schema

Catalog Schema

Attribute

CatalogSchema (CS)

Purpose

Specifies the DB2 schema to use for Catalog functions. Specifying a schema allows you to use copies or views of the system catalog tables for catalog functions.

Valid Values

schema_name

where:

schema_name

is the name of a valid DB2 schema. If you do not specify a value for this attribute, the driver uses SYSIBM when connected to DB2 for z/OS, QSYS2 when connected to DB for ii, and SYSCAT when connected to Linux/UNIX/Windows.

Example

Create a view DB2ADMIN.TABLES from SYSCAT.TABLES.

CREATE VIEW DB2ADMIN.TABLES AS SELECT * FROM SYSCAT.TABLES WHERE OWNER LIKE 'ODBC%'

Set CatalogSchema=DB2ADMIN, and do the SQLTables thing.

"TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "TABLE_TYPE", "REMARKS"

The results come from the DB2ADMIN.TABLES view. Three rows are fetched from five columns.

<Null>, "DB2ADMIN", "BUG", "TABLE", <Null>
<Null>, "DB2ADMIN", "DATETEST", "TABLE", <Null>
<Null>, "DB2ADMIN", "TESTCP", "TABLE", <Null>

Default

None

GUI Tab

Advanced tab