Use session option set repmode to set replication mode to SQL statement replication. You can specify session-level settings either when you log in, or at the beginning of a batch job. Session-level settings override both database-level and object-level settings.Use set repmode on to enable SQL statement replication for the DML operation specified, for the duration of the session. Use set repmode off to remove all SQL statement replication settings at the session level. For example, to replicate only select into and delete as SQL statements for the duration of the session, enter:
set repmode on 'DS'
See “set repmode” in the “System Changes” chapter in the Adaptive Server Enterprise 15.0.3 New Features Guide.
