Use process actions to define or modify actions to occur
at the beginning or end of a process. For example, you might use an
action to record the time at which a process begins or, at the time
the process is complete, to record the name of a file generated by
the process.
To define process actions:
- Open the access definition or table map for which actions
are needed.
- In the Access Definition Editor, click
the Selections tab and the Actions tab.
In the Table Map Editor, click the Table
Map tab and the Actions tab. Supported process action phases are listed.
- 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.