Information icon IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5
space Feedback

Activity properties

When you have outlined your basic design by adding activities and triggers to the diagram window, you fill in the details by editing the properties of the activities.

To edit an activity, do one of the following:

  • Double-click the activity in the Diagram window.
  • Select the activity and choose Properties... from the shortcut menu.
  • Select the activity and choose Edit ► Properties.

The format of the Properties dialog box depends on the type of activity. All have a General page, however, and any activities with output triggers have a Triggers page.

The General page contains:

  • Name. The name of the activity, you can edit the name here if required.
  • Description. An optional description of the activity.
  • Logging text. The text that will be written to the Director log when this activity is about to run.

The Triggers page contains:

  • Name. The name of the output trigger.
  • Expression Type. The type of expression attached to the trigger. Choose a type from the drop-down list (see "Triggers" for an explanation of the different types).
  • Expression. The expression associated with the trigger. For most predefined conditions, this is fixed and you cannot edit it. For Custom conditions you can enter an expression (see "Expressions"), and for UserStatus conditions you can enter a text message.

You can use variables when defining trigger expressions for Custom and ReturnValue conditional triggers. The rules are given in the following table:

Table 1. Variables used in defining trigger expressions
Activity Type Variable Use
Job stage_label.$ExitStatus stage_label.$UserStatus stage_label.$JobName Value of job completion status Value of job's user status Name of job actually run, including invocation id, if present.
ExecCommand stage_label.$ReturnValue stage_label.$CommandName stage_label.$CommandOutput Command status Name of command executed (including path name if one was specified) Output captured by executing the command
Routine stage_label.$ReturnValue stage_label.$RoutineName Value of routine's return code Name of routine called
Wait-for-File stage_label.$ReturnValue Value returned by DSWaitForFile before/after subroutine
Exception Handler (these are available for use in the sequence of activities the stage initiates, not the stage itself) stage_label.$ErrSource.

stage_label.$ErrNumber.

stage_label.$ErrMessage.

The stage label of the activity stage that raised the exception (for example, the job activity stage calling a job that failed to run).

Indicates the reason the Exception Handler activity was invoked, and is one of:

1. Activity ran a job but it aborted, and there was no specific handler set up.

-1. Job failed to run for some reason.

The text of the message that will be logged as a warning when the exception is raised.

stage_label is name of the activity stage as given in the Diagram window. You can also use the job parameters from the job sequence itself.

Custom conditional triggers in Nested condition and Sequencer activities can use any of the variable in the above table used by the activities connected to them.

The specific pages for particular activities are described in the following sections.

  • Job activity properties
    In addition to the General and Triggers pages, The Properties dialog box for a job activity contains a Job page.
  • Routine activity properties
    In addition to the General and Triggers pages, the Properties dialog box for a routine activity contains a Routine page.
  • Email Notification activity properties
    Besides a General page, the properties dialog box has a Notification page. An email notification activity can only have a single unconditional output trigger, so does not require a Triggers page.
  • Wait-For-File activity properties
    In addition to the General and Triggers pages, The Properties dialog box for a wait-for-file activity contains a Wait For File page.
  • ExecCommand activity properties
    In addition to the General and Triggers pages, The Properties dialog box for a ExecCommand activity contains an ExecCommand page.
  • Exception activity properties
    An exception activity handles the situation where a job in the sequence fails to run (other exceptions in the job sequence are handled by triggers).
  • Nested Condition activity properties
    A nested condition allows you to further branch the execution of a sequence depending on a condition.
  • Sequencer activity properties
    A sequencer allows you to synchronize the control flow of multiple activities in a job sequence. It can have multiple input triggers as well as multiple output triggers.
  • Terminator activity properties
    A terminator stage can be placed in a job sequence to ensure that the sequence is stopped cleanly if certain situations arise.
  • Start Loop activity properties
    The Start Loop stage marks the beginning of the loop and defines it.
  • End Loop activity properties
    The end loop stage marks the end of the loop.
  • User Variables activity properties
    Use the user variable stage to define global variables within a sequence.
Parent topic: Building job sequences

PDFThis topic is also in the IBM InfoSphere DataStage and QualityStage Designer Client Guide.

Update timestamp Last updated: 2011-12-8