Federated system INSERT, UPDATE, and DELETE restrictions

Some restrictions apply to using INSERT, UPDATE, or DELETE statements in a federated system.

The following restrictions apply to updates on nicknames:

  • A data source object that is read-only, such as a JOIN view, cannot be updated
  • You cannot perform insert, update, and delete operations on federated views created with UNION ALL statements. Federated views created with UNION ALL statements are read-only views.
  • A federated insert, update, or delete operation, or a call to federated procedure with an SQL data access indication of MODIFIES SQL DATA is invalid in a function, a data-change-table-reference, a compound statement that specifies ATOMIC (with the exception of the Db2®, and Windows data source), a trigger, and an application execution environment where any of the following is true:
    • SAVEPOINT is in effect (with the exception of the Db2 data source)
    • Scrollable cursor is used
    • Target view contains multiple tables or nicknames