There are several limitations to be aware of when you use dynamic SQL.
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.