Verifying that a Primary Database Object Is Marked for Replication

In a Sybase transaction replication system, both Replication Agent and Replication Server allow you to select the objects that you want to replicate. You do not need to replicate all objects or all data-changing operations in the primary database.

1. Log in to the Replication Agent instance with the administrator login.
   
2. Determine if the object is already marked:

   • For a table:

     pdb_setreptable pdb_table

     where pdb_table is the name of the primary database table that you want to verify is marked for replication.

   • For a LOB column:

     pdb_setrepcol pdb_table, pdb_col

     • where pdb_table is the marked table that contains the LOB column.

     • where pdb_col is the LOB column.

   • For a stored procedure:

     pdb_setrepproc pdb_proc

     where pdb_proc is the name of the stored procedure in the primary database that you want to verify is marked for replication.

   • For DDL:

     pdb_setrepddl object

     where object is a table, procedure, or sequence name. See the Replication Agent Reference Manual for details on using the pdb_setrepddl command.

   • For sequences:

     pdb_setrepseq pdb_seq

     where pdb_seq is the name of the sequence that you want to verify is marked for replication.