Passthrough mode is started using the PASSTHROUGH statement and it is stopped using the PASSTHROUGH STOP statement. A passthrough session refers to the statements entered between the PASSTHROUGH statements. Statements entered in a passthrough session:
Are checked for syntax errors.
Are executed at the consolidated database unless you supply the ONLY keyword. When ONLY is specified, the statements are sent to the remote database without being executed on the consolidated database.
The following statement starts a passthrough session, which passes the statements to a list of two named subscribers, without being executed at the current database:
PASSTHROUGH ONLY FOR userid_1, userid_2;
Are passed to the identified subscriber database. Passthrough statements are replicated in sequence with normal replication messages, in the order in which the statements are recorded in the transaction log.
Are executed at the subscriber database.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|