Set up the Configuration Parameters to Use Dynamic SQL

You can enable or configure dynamic SQL at the server or database connection level.

Dynamic SQL is off by default at a server and connection level.

Set the dynamic SQL configuration parameters at the server-level to provide the default values for the connections created or started in the future. To configure dynamic SQL at the server level, enter:

configure replication server 
set { dynamic_sql |
      dynamic_sql_cache_size |
      dynamic_sql_cache_management }
to value

To configure dynamic SQL at the connection level, enter:

alter connection to server.db
set { dynamic_sql |
      dynamic_sql_cache_size |
      dynamic_sql_cache_management }
to value