ASA SQL User's Guide
Accessing Remote Data
Working with proxy tables
The AT keyword is used with both CREATE TABLE and CREATE EXISTING TABLE to define the location of an existing object. This location string has four components, each separated by either a period or a semicolon. The semicolon delimiter allows filenames and extensions to be used in the database and owner fields.
The syntax of the AT clause is
... AT 'server.database.owner.table-name'
Server This is the name by which the server is known in the current database, as specified in the CREATE SERVER statement. This field is mandatory for all remote data sources.
Database The meaning of the database field depends on the data source. In some cases this field does not apply and should be left empty. The periods are still required, however.
In Adaptive Server Enterprise, database specifies the database where the table exists. For example master or pubs2.
In Adaptive Server Anywhere, this field does not apply; leave it empty.
In Excel, Lotus Notes, and Access, you must include the name of the file containing the table. If the file name includes a period, use the semicolon delimiter.
Owner If the database supports the concept of ownership, this field represents the owner name. This field is only required when several owners have tables with the same name.
Table-name This specifies the name of the table. In the case of an Excel spreadsheet, this is the name of the "sheet" in the workbook. If the table name is left empty, the remote table name is assumed to be the same as the local proxy table name.
The following examples illustrate the use of location strings:
Adaptive Server Anywhere:
'testasa..DBA.employee'
Adaptive Server Enterprise:
'ASEServer.pubs2.dbo.publishers'
Excel:
'excel;d:\pcdb\quarter3.xls;;sheet1$'
Access:
'access;\\server1\production\inventory.mdb;;parts'