The MERGE INTO function is supported on primary and compute clusters for Object File Storage (OFS) tables. The following operations can be performed:
- WHEN MATCHED, THEN UPDATE
- WHEN NOT MATCHED, THEN INSERT
- WHEN MATCHED, THEN DELETE
The MERGE INTO function is not supported when there are triggers defined on the target table or when there are LOB columns present in the target table.
The following are use cases of the MERGE INTO function on an OFS table:
- Target is OFS table, and source is a foreign table that is OFS or Open Table Format (OTF).
- Target is OFS table, and source is BFS table.
- Target is OFS table and source is a mix of foreign tables and Block File System (BFS) tables.
- Target is OFS table and source is a derived table with any number of tables (foreign tables or BFS) and different operations that are allowed in derived table.
- Target is BFS table and primary index (PI) is not referred to in the ON clause or target is NO-PI table.