Merging Data Into an Existing Data Source With ON TABLE MERGE
The ON TABLE MERGE clause in a TABLE or TABLEF command enables you to insert, update, and delete records in an existing single-segment data source.
Data sources that support insert, update, and delete operations, either for individual records or bulk load, can take advantage of the full set of options for ON TABLE MERGE. Relational data sources support all of these options. Other data sources, such as delimited and fixed format sequential data sources, can only have records appended to the existing data source.