Enable SQL Statement Replication

You can enable SQL statement replication at the database, table or session level. Session settings override both table and database settings. Table settings override database settings.

Several Adaptive Server stored procedures support SQL statement replication.

• Enable SQL Statement Replication at the Database-level
  Use sp_setrepdbmode to enable SQL statement replication at the database-level for a specific DML operation.
• Enable SQL Statement Replication at the Table Level
  Use sp_setrepdefmode to configure SQL statement replication at the table-level. Table-level settings override database-level settings.
• Enable SQL Statement Replication at the Session Level
  Use set repmode to configure SQL statement replication for the DML operation specified, for the duration of the session. Session settings override both database-level and object-level settings.