Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Remote » Managing SQL Remote systems » SQL Remote passthrough mode

 

Start and stop passthrough mode

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.

 Direct passthrough statements
 Data modification language (DML)
 See also