Database-level

Use sp_setrepdbmode and sp_reptostandby to 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. The DML operations that apply to SQL statement replication include:

• U – update

• D – delete

• I – insert select

• S – select into

For example, to replicate delete statements as SQL statements and also enable replication of select into, enter:

sp_setrepdbmode pdb, 'DS', 'on'

When an user executes a delete on a table in database pdb, Adaptive Server logs additional information for SQL statement replication. The RepAgent sends both individual log records, and the information needed by the Replication Server, to build the SQL statement.You can set SQL statement replication at the database level only when the database has been marked for replication by setting sp_setreptostandby to ALL or L1.

Use sp_reptostandby to display the SQL statement replication status at the database level. For example:

sp_reptostandby pdb
go
The replication status for database 'pdb' is 'ALL'.
The replication mode for database 'pdb' is 'off'.