Target Table Restrictions

The following restrictions apply to the target table of the MERGE statement. If any of the following conditions exist, MERGE returns an error.

• The target table of MERGE cannot have any violations tables defined
• The target table of MERGE cannot be an external table nor a remote table
• The target table of MERGE cannot be a system catalog table
• The target table of MERGE cannot be a static table nor a duplicated table
• The target table of MERGE cannot be a pseudo-table (a memory-resident object in a system database) nor a read-only view
• If an Update or Insert trigger is defined on the target table of MERGE, an error is issued. (Here MERGE does not act as a triggering event.)