ASA SQL User's Guide
  Accessing Remote Data
    Working with proxy tables

Creating proxy tables with the CREATE EXISTING TABLE statement

The CREATE EXISTING TABLE statement creates a proxy table that maps to an existing table on the remote server. Adaptive Server Anywhere derives the column attributes and index information from the object at the remote location.

To create a proxy table with the CREATE EXISTING TABLE statement (SQL)

1. Connect to the host database.

2. Execute a CREATE EXISTING TABLE statement.

For more information, see the CREATE EXISTING TABLE statement.

Example 1 

To create a proxy table called p_employee on the current server to a remote table named employee on the server named asademo1, use the following syntax:

CREATE EXISTING TABLE p_employee
AT 'asademo1..DBA.employee'

Example 2 

The following statement maps the proxy table a1 to the Microsoft Access file mydbfile.mdb. In this example, the AT keyword uses the semicolon (;) as a delimiter. The server defined for Microsoft Access is named access.

CREATE EXISTING TABLE a1
AT'access;d:\mydbfile.mdb;;a1'