Replication Server lets you replicate Adaptive Server stored procedure invocations asynchronously between databases. This method can improve performance over normal data replication by encapsulating many changes in a single replicated function. Because they are not associated with table replication definitions, replicated functions can execute stored procedures that may or may not modify data directly.
You can replicate stored procedure invocations from a primary database to a replicate database, or from a replicate database to a primary database. See “Using applied functions” and “Request functions” for details.
With replicated functions, you can execute a stored procedure in another database. A replicated function allows you to:
Replicate the execution of an Adaptive Server stored procedure to subscribing sites
Improve performance by replicating only the name and parameters of the stored procedure rather than the actual changes
Like tables, replicated stored procedures may have replication definitions, which are called function replication definitions, and subscriptions. When a replicated stored procedure executes, the Replication Server passes its name and execution parameters to subscribing sites, where the corresponding stored procedure executes.
You create function replication definitions at the primary data site. Replication Server supports applied functions and request functions:
An applied function is replicated from a primary to a replicate database. You create subscriptions at replicate sites for the function replication definition and mark the stored procedure for replication in the primary database. The applied function is applied at replicate database by maint_user.
A request function is replicated from a primary to a replicate database. You create subscriptions at replicate sites for the function replication definition and mark the stored procedure for replication in the primary database. The request function is applied at replicate database by the same user who executes the stored procedure at the primary database.
