This variable indicates the catalog name to be used when Database Connectors searches for objects in the database. Note that not all data sources will support a catalog. Using A_ODBC_CATALOG with other variables, such as USER_PATH and A_ODBC_TABLE_TYPES, can speed up the finding of tables in large databases. It can also prevent an error 9D,14: More than one table with the same name, thereby enabling access to tables with identical names, but with different catalogs.
For example, If USER_PATH and A_ODBC_CATALOG are used, the form of the SQL statement is modified from:
select COL1, ... from TABLENAME ...
to
SELECT COL1, ... FROM [catalog.][username.]TABLENAME ...
where catalog and username are filled in if provided.
See Also: USER_PATH (for DB2) configuration variable, USER_PATH (for Oracle) configuration variable, and A_ODBC_TABLE_TYPES.