Defining process actions

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:

  1. Open the access definition or table map for which actions are needed.
  2. 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.
  3. 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.
  4. 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.
  5. Click OK.

    If the syntax is not valid, you are prompted.

  6. Save the access definition.


Feedback