Proxy Tables

A proxy table is a local table containing metadata which points to a remote object, and are the key to location transparency.

The remote table is mapped to the proxy table to make it appear as if it were a local table.

• Using the create table Command
  The create table command creates a proxy table and a remote table at the same time.
• Using the create existing table Command
  The create existing table command allows the definition of existing tables (proxy tables).
• Using the create proxy_table Command
  Using the create proxy_table command does not require a column list: Component Integration Services derives the column list from the metadata it obtains from the remote table.
• Remote Procedures as Proxy Tables
  You can add an optional clause to the create existing table statement to indicate the remote object is actually a stored (or other) procedure instead of a table.
• Server Limits
  SAP ASE configuration allows page sizes of 2K, 4K, 8K, or 16K bytes.
• Cascading Proxy Tables
  SAP ASE allows cascading proxy table configurations between any number of instances of Component Integration Services.