Passthrough Script Properties window: General tab

Note

SQL passthrough functionality has been deprecated. Changing SQL passthrough information will only affect version 11.x clients.

This tab has the following components:

  • Name   Shows the name of the passthrough script.

  • Type   Shows the type of object.

  • Flags   Shows the flags that are set. A flag is an instruction that tells clients how to run the script. This value can be NULL or contain a combination of the following keywords:

    • Manual   This flag indicates that the script can only be run in manual execution mode. By default, scripts are run in automatic execution mode.

    • Exclusive   This flag indicates that the script can only be automatically executed at the end of a synchronization where exclusive locks were obtained on all tables being synchronized. This flag is ignored if the passthrough script does not list any affected publications. This flag is only meaningful for SQL Anywhere remote databases.

    • Schema diff   This flag indicates that the script should be run in schema-diffing mode. In this mode, the database schema is altered to match the schema described in the script. For example, a CREATE TABLE statement for an existing table is treated as an ALTER TABLE statement. This flag only applies to UltraLite remote databases.

  • Affected publications   Lists the publications that must be fully synchronized before the script is run. An empty publication indicates that no synchronization is required.

  • Description   Provides a place for you to type a text description of the passthrough script.