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 Db2 for i, 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