Use the Insert Request Table Specification dialog to specify whether a destination table is to be processed in a certain way during an Insert Request. The types of processing available depend upon whether you select the Mixed Delete Option or the Mixed Processing Option.
When you select the Mixed Delete Option, use the Insert Request Table Specification dialog to select tables from which data is deleted before Insert processing occurs. You can click or simply save, run, or schedule the Insert Request to display the Insert Request Table Specification dialog automatically.
The Insert Request Table Specification dialog contains a Delete column, which you can use to indicate the tables from which data is deleted before Insert processing occurs.
When you select the Mixed Processing Option, use the Insert Request Table Specification dialog to select the type of processing for each table before Insert processing occurs. You can click or simply save, run, or schedule the Insert Request to display the Insert Request Table Specification dialog automatically.
For each table, you can click the Update grid cell to select a process option from the drop-down list. The process options include Insert, Update/Insert, and Update Only. You can also right-click and use shortcut menu commands to select an option for all tables. If all tables are set to a single option, the Process Option changes to match.