Verify Replication Definition RCL Commands

Use admin verify_repserver_cmd to verify replication definition RCL commands.

When Replication Agent sends a replication definition RCL to Replication Server to execute, and the replication definition RCL fails to execute, Replication Agent shuts down. To avoid this situation, Sybase recommends that you use admin verify_repserver_cmd at the primary database to verify that Replication Server can successfully execute a replication definition request before you execute the RCL directly from the primary database. Replication Server returns an error if it cannot successfully execute the request.

Replication Server supports admin verify_repserver_cmd for the same replication definition commands as rs_send_repserver_cmd:

alter replication definition
create replication definition
drop replication definition
alter applied function replication definition
create applied function replication definition
alter request function replication definition
create request function replication definition

This example shows that admin verify_repserver_cmd can detect syntax errors, such as using the “columns” keyword in the command line:

admin verify_repserver_cmd, ‘alter replication
definition authors drop columns address, city, state, zip
with DSI_suspended’

Replication Server returns with a message, such as:

Line 1, character 71: Incorrect syntax with the keyword
'columns'.