Use passthrough mode to pass standard SQL statements to a remote database where they can be executed.
You must have the SYS_RUN_REPLICATION_ROLE system role.
You can use passthrough mode to complete the following tasks on a running SQL Remote system:
SQL Remote relies on each database in the system having the same objects; when a table is altered at some sites but not at others, attempts to replicate data changes fail. Additional schema changes executed on a running SQL Remote system might cause problems.
Test your passthrough operations on a copy of the consolidated database with a copy of a remote database subscribed. Never run untested passthrough scripts on a production database.
Qualify object names with the owner name. PASSTHROUGH statements are not executed on remote databases from the same user name. Object names without the owner name qualifier may not be resolved correctly.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|