This chapter describes how to replicate the execution of a stored procedure from the source to the destination database using replicated functions.
When you use function replication, Replication Server copies the execution of a stored procedure to the destination database. That is, you execute a stored procedure at the source database, which 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.
Refer to the Replication Server Design Guide for information about replication system design issues that concern replicated stored procedures.
This chapter covers the distribution of stored procedures via function replication definitions. The distribution of stored procedures associated with table replication definitions is described in Appendix A, “Asynchronous Procedures,” in the Replication Server Administration Guide Volume 2.
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 distribute, to replicate databases, an operation first performed in a primary database. See “Applied functions” for more information.
A request function to deliver a transaction from a replicate database to the primary database. See “Request functions” for more information.
