ODBC or JDBC Access to the Data Catalog: Qualified Names

To refer to a SQL view (table), database operation, or data service using ODBC or JDBC, you must specify its three-part qualified name.

Specify qualified names in this format:

<catalog>.<schema>.<object>

<catalog> is the name of the Data Federation domain in which the object is defined. The <schema> portion of the name can be one of the following:

• A database connector name. For example, if you establish a database connector called “CustomerDb,” all SQL views and database operations defined on that connector have CustomerDb as the schema portion of their name.

• The literal “DATASERVICE”. This is the schema in which all data services and SQL views generated from them are deployed.

• The literal “VirtualDb”. This is the schema in which virtual database operations and SQL views generated from them are deployed.

<object> is the name of the SQL view, database operation, or data service that you want to access.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com