Dynamic SQL has these limitations:
If a table is replicated to a standby or MSA connection using an internal replication definition, and dynamic SQL is enabled for the connection, any new replication definition for the table should define the column order consistent with the column order in the primary database. Otherwise, the existing prepared statements may be invalidated, and may require the standby or MSA connection to be restarted.
Replication Server converts user-defined datatypes to Open Client/Server™ (OCS) datatype in a dynamic SQL command.
If data falls outside Sybase ranges that cause dynamic SQL to fail, DSI logs an error message and resends dynamic SQL using the language command. DSI shuts down only if the language command also fails.
If this condition happens frequently, disable dynamic SQL from the table replication definition or use the set dynamic_sql off command.
Use any of these commands to turn off dynamic_sql:
alter connection... set dynamic_sql off – turns dynamic SQL off for all commands in this connection.
create/alter replication definition...without dynamic_sql – turns dynamic SQL off for all commands using this replication definition.
set dynamic_sql off for replication definition with replicate at... – turns dynamic SQL off for all commands using this replication definition at this replicate connection.
