Symptom
- Replication could be configured to replicate the SQL Statements rather than the data modified by the Statements. (SQLDML).
- There are multiple restrictions which can prevent SQL Statement Replication. Limitations are described in :
- If SQL query is rejected for Statement Replication, then Replication Server switch back to the normal row by row replication to replicate data.
- For complex query, it could be very difficult to diagnose the reason why the query was rejected.
Read more...
Environment
- SAP Replication Server (SRS) 16.0
- SAP Replication Server (SRS) 15.7.1
Product
SAP Replication Server 15.7 ; SAP Replication Server 16.0
Keywords
SQLDML, replicate query, SQL replication, SQL Statement Replication , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview