Actions are supplemental SQL statements (actions) to be executed at selected phases of an archive, delete, insert, extract, or restore process. You typically create actions in an access definition. You can define actions for all phases, including insert or restore phases, in the access definition. The access definition is copied to the archive or extract file during the processing. Any insert actions in the access definition become the default actions when data is inserted. These actions can be overridden in the table map that is used in the restore, insert, or load process.
From the Table Map Editor, you can create, modify, or delete one or more default actions that pertain to the action phases of an insert or restore Process. If one or more variables are defined in the access definition used to create the archive or extract file, you can include them in an action defined in the table map.
Right-click a table name in the source table column in the Table Map Editor to select from the following commands: