Location transparency of remote data is enabled by creating a local proxy table that maps to the remote object. You can use a proxy table to access any object (including tables, views, and materialized views) that the remote database exports as a candidate for a proxy table. Use one of the following statements to create a proxy table:
You cannot modify data in a proxy table when you are within a savepoint. See Savepoints within transactions.
When a trigger is fired on a proxy table, the permissions used are those of the user who caused the trigger to fire, not those of the proxy table owner.
Specifying proxy table locations
Creating proxy tables (Sybase Central)
Creating proxy tables with the CREATE EXISTING TABLE statement
Creating a proxy table with the CREATE TABLE statement
Listing the columns on a remote table
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|