User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To start or stop passthrough mode for SQL Remote administration. Forms 1 and 2 start passthrough mode, while form 3 stops passthrough mode.

Syntax

     Syntax 1.     PASSTHROUGH [ ONLY ] FOR userid,...

     Syntax 2.     PASSTHROUGH [ ONLY ] FOR SUBSCRIPTION
          ... TO [ ( owner) ].publication-name [ ( constant) ]

     Syntax 3.     PASSTHROUGH STOP

Usage

Anywhere. This statement is applicable only to SQL Remote.

Permissions

Must have DBA authority.

Side effects

None.

Description

In passthrough mode, any SQL statements are executed by the database server, and are also placed into the transaction log to be sent in messages to subscribers. If the ONLY keyword is used to start passthrough mode, the statements are not executed at the server; they are sent to recipients only. The recipients of the passthrough SQL statements are either a list of user IDs (form 1) or all subscribers to a given publication. Passthrough mode may be used to apply changes to a remote database from the consolidated database or send statements from a remote database to the consolidated database.

Syntax 2 sends statements to remote databases whose subscriptions are started, and does not send statements to remote databases whose subscriptions are created and not started.

Example

     PASSTHROUGH FOR rem_db ;
     ...
     ( SQL statements to be executed at the remote database )
     ...
     PASSTHROUGH STOP ;