To add new parameters, add new searchable parameters, or change the name of the destination stored procedure, use alter applied function replication definition and alter request function replication definition commands to alter the function replication definition. The syntax for the commands:
alter applied function replication definition
alter applied function replication definition function_applied_rep_def
{with replicate function named ‘proc_name‘ |
add @param_name datatype[, @param_name datatype]... |
add searchable parameters @param_name[, @param_name]... |
send standby {all | replication definition} parameters ...|
}[with DSI_suspended]
alter request function replication definition
alter request function replication definition function_request_rep_def
{with replicate function named ‘proc_name‘ |
add @param_name datatype[, @param_name datatype]... |
add searchable parameters @param_name[, @param_name]... |
send standby {all | replication definition} parameters ...|
}[with DSI_suspended]
These two commands are used to change the function replication definitions created by create applied function replication definition and create request function replication definition command respectively. See Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for more information about alter applied function replication definition and alter request function replication definition commands.
See Appendix C, “Pre-15.1 Request Function Replication” in the Replication Server Administration Guide Volume 2 for information on modifying pre-15.1 function replication definition.
See “Creating or modifying a function string for a replicated function” for information about function strings for function replication definitions.
To add new searchable parameters to the where clause of a define subscription command, drop and re-create the subscription for the function replication definition. For more information about subscribing to function replication definitions, see “Implementing an applied function” and “Implementing a request function”.
