Manage Replicated Functions

Use replicated functions to replicate the execution of a stored procedure from the source database to the destination database.

When you use function replication, Replication Server replicates the execution of a stored procedure from the source database to the destination database. That is, when a stored procedure is executed at the source database, the Replication Server invokes the execution of another stored procedure at the destination database. The two stored procedures need not have the same name nor perform the same tasks.

See the Replication Server Design Guide for information about replication system design issues that concern replicated stored procedures.

See Replication Server Administration Guide Volume 2 > Asynchronous Procedures for the distribution of stored procedures associated with table replication definitions. See Replication Server 15.6 Administration Guide Volume 2 > Pre-15.1 Request Function Replication for the request function distribution without subscription for versions earlier than 15.1.

You identify the stored procedure at the source and the information that is to be passed to the destination by creating a function replication definition, which specifies:

The names of the stored procedures at the source and destination databases (if they are different)
The datatypes and parameters that are to be passed to the destination stored procedure

To satisfy the requirements of distributed applications, Replication Server provides two ways to implement replicate functions. Use:

An applied function to deliver a transaction to a replicate database by the maintenance user.
A request function to deliver a transaction to a replicate database by the same user who invokes the stored procedure at the primary database.

The maint_user runs the transaction at the replicate database if the function is replicated through applied function replication definition. The origin_user runs the transaction if the function is replicated through request function replication definition at the replicate database.

Prerequisites and Restrictions for Replicated Functions
Before you implement applied or request functions in your replication system, be sure that you have met the prerequisites, and that you understand the restrictions on the use of replicated stored procedures.
Commands for Managing Function Replication Definitions
Learn the commands you can use to work with function replication definitions.
Use Replicated Functions
A replicated stored procedure is an Adaptive Server stored procedure that you have marked for replication using either sp_setrepproc or sp_setreplicate. A function replication definition describes the primary and the replicated stored procedure, its parameters, and its location.
Mark Stored Procedures for Replication
Use the sp_setrepproc system procedure to mark stored procedures for replication.
Subscribe to Replicated Functions
You must create subscriptions to function replication definitions for either applied or request functions using create subscription and the no-materialization method or define subscription and the other commands for bulk materialization: activate subscription, validate subscription, and check subscription.
Modify or Drop Replicated Functions
Learn how to modify or drop replicated functions.
Use Publications for Stored Procedures
You can use publications to select stored procedures and/or tables, along with their replication definitions, and subscribe to all of them as a group. Publications let you organize your replication definitions and subscriptions and then monitor their status with a single command.

Related concepts

Applied Functions

Request Functions