Set SQL Statement Replication Threshold

You can trigger SQL statement replication without having to set the threshold on individual tables.

In Adaptive Server 15.0.3, you could only set the threshold at the table level.

By default, SQL statement replication is triggered when the SQL statement affects more than 50 rows. You can set different threshold values at the session, database, and table-levels.

However, the threshold set at the session level overrides the threshold at the table level and database level, and the threshold set for any table overrides the threshold set at the database level.

• Set Thresholds and Operations at Database Level
  Use the threshold parameter for the sp_setrepdbmode command to set thresholds at the database level.
• Set Thresholds and Operations at Session Level
  Use set repthreshold to set thresholds at the session level.
• Set Thresholds and Configure Replication
  You can have a database that is not configured for replication and set the threshold for SQL statement replication at the database level at the same time.