Use the Table Specifications window
to define or modify actions to occur before or after the first or
last row in a table is processed or before or after each row in the
table is processed in an archive, delete, insert or restore process.
- Open the access definition for which actions are needed.
- In the Access Definition Editor, click
the Selections tab and the Tables tab.
- To add an action for a listed table, select the table name,
right-click, and select Add Actions from the
menu. The Table Specification window
opens on the Actions tab.
- Select an action type for the appropriate
phase.
- Select Action reuse to use an action
linked to another phase in the list. Action is
populated with the first phase for which an SQL action type is specified.
Use the Action dropdown to change this default
selection.
- Select SQL and click Add to
open the Table Specification window.
- In the Table Specification window,
you can:
- Create the SQL statement and check the syntax.
- Limit the execution of the action to a specific solution.
- Insert or create and insert variables into the statement.
- Select and insert column names into the statement.
- Set options for errors when processing the statement.
- Click OK.
If
the syntax is not valid, you are prompted.
- Save the access definition.