• Only the owner of a table or a user with replace permission on the table can replace values.

• The replace statement fires any rules defined on the specified table that is fired by an equivalent SQL update statement. For more information, see the SQL Reference Guide.

• If the table was created with no duplicate rows allowed, you cannot execute a replace that creates a duplicate row.

• If the row update violates an integrity constraint, the update is not performed.

• Do not mix explicitly declared range variables with default range variables. Mixing range variables results in a disjoint query, which can seriously corrupt your data. For details, see Range Statement—Associate Range Variables with Tables.