Defining table actions

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.

To define table actions:

  1. Open the access definition for which actions are needed.
  2. In the Access Definition Editor, click the Selections tab and the Tables tab.
  3. 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.
  4. 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.
  5. 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.
  6. Click OK.

    If the syntax is not valid, you are prompted.

  7. Save the access definition.


Feedback