ASA SQL User's Guide
Accessing Remote Data
Basic concepts to access remote data
Adaptive Server Anywhere presents tables to a client application as if all the data in the tables were stored in the database to which the application is connected. Internally, when a query involving remote tables is executed, the storage location is determined, and the remote location is accessed so that data can be retrieved.
To have remote tables appear as local tables to the client, you create local proxy tables that map to the remote data.
To create a proxy table
Define the server where the remote data is located. This specifies the type of server and location of the remote server.
For more information, see Working with remote servers.
Map the local user login information to the remote server user login information if the logins on the two servers are different.
For more information, see Working with external logins.
Create the proxy table definition. This specifies the mapping of a local proxy table to the remote table. This includes the server where the remote table is located, the database name, owner name, table name, and column names of the remote table.
For more information, see Working with proxy tables.
To manage remote table mappings and remote server definitions, you can use Sybase Central or you can use a tool such as Interactive SQL and execute the SQL statements directly.