Enable RTL at the database level.
Prerequisites
Set
dsi_bulk_copy and
dynamic_sql to
off before you enable real-time loading (RTL) replication to
Sybase IQ.
Task- To enable and configure
RTL at the database level to affect only the specified database, enter:
alter connection to IQSRVR.iqdb
set dsi_compile_enable to ‘on’
go
- Suspend and resume the connection to the replicate
Sybase IQ database to enable the change to the connection:
suspend connection to IQSRVR.iqdb
go
resume connection to IQSRVR.iqdb
go