Was this helpful?
Considerations
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--Associate Range Variables with Tables.
Last modified date: 01/30/2023