INF: Default Schema to be Used with ODBC Driver for DB2 and OLE DB Provider for DB2

Article translations Article translations
Article ID: 217757 - View products that this article applies to.
This article was previously published under Q217757
Expand all | Collapse all

SUMMARY

Default Schema is the name of the DB2 collection where the driver or the provider looks for catalog information. This is an optional parameter that can be specified while configuring ODBC and OLE DB Data Sources for DB2 to restrict results sets for popular operations, such as enumerating a list of tables in a target collection (for example, ODBC Catalog SQLTables).

If this paramater is not specified (left blank), the driver or the provider uses the default values depending on the platform that DB2 is running on. For DB2 (on Mainframe), it defaults to SYSIBM, for DB2/400 it defaults to QSYS2, and for UDB the default value is SYSCAT.

Retrieving all the tables within these global defaults could be time consuming for the driver and the provider, therefore, it is recommended that you specify the name of the target collection whenever possible.

Properties

Article ID: 217757 - Last Review: March 8, 2005 - Revision: 2.1
APPLIES TO
  • Microsoft OLE DB Provider for DB2
  • Microsoft ODBC Driver for DB2 4.0 SP2
Keywords: 
kbinfo KB217757

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com