Disable Dynamic SQL

There are several commands you can use to disable 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.