A proxy table is a local table containing metadata used to access a table on a remote database server as if it were a local table. These let you import data directly.
Use proxy tables to import data when you:
Changes are recorded in the transaction log when you import using proxy tables. This means that if there is a media failure involving the database file, you can recover information about the changes you made from the transaction log.
Create a proxy table, and then use an INSERT statement with a SELECT clause to insert data from the remote database into a permanent table in your database.
For more information about remote data access, see Accessing remote data.
For more information about INSERT statements, see INSERT statement.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|