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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Replication » Replicating data with Replication Server » Using the LTM


Preparing procedures and functions for replication

You can use stored procedures to modify the data in tables. Updates, inserts, and deletes execute from within the procedure.

Replication Server can replicate procedures as long as they satisfy certain conditions. The first statement in a procedure must perform an update for the procedure to be replicated.

For a full description of how Replication Server replicates procedures, see your Replication Server documentation.

SQL Anywhere supports two dialects for stored procedures: the Watcom-SQL dialect, based on the draft ISO/ANSI standard, and the Transact-SQL dialect. You must use Transact-SQL to write stored procedures for replication.

Function APC format

The SQL Anywhere LTM supports the Replication Server function APC format. To make use of these functions, set the configuration parameter rep_func to on (the default is off).

The LTM interprets all replicated APCs as either table APCs or function APCs. A single SQL Anywhere database cannot combine function APCs with other table APCs.

For more information about replicate functions, see your Replication Server documentation.