You can trigger SQL statement replication without having to set the threshold on individual tables. You can set the threshold at the:
Database-level – using Adaptive Server 15.0.3 ESD #1 and later.
Session-level – using Adaptive Server 15.0.3 ESD #2 and later.
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.
