In replication, an action that is taken when an SQL statement fails against a target table and the resulting SQL return code indicates that another SQL statement could be used to produce the desired result in the target table. An example is the conversion of an insert into a replication target table to an update if the insert fails because the row already exists in the target table. Another example is the conversion of an update to a replication target table to an insert if the update fails because the row does not exist in the target table.