Properties tab (DataStage)

Specify the options that the Build stage requires as properties. For user-defined stages, properties always appear in the Properties section under the Stage tab.

To add a property, click Add property + and fill in the fields as follows:

  • Name is the name of the property. This will be passed to the operator you are defining as an option, prefixed with `-' and followed by the value selected in the Properties section of the Stage tab.
  • Data type is the data type of the property. Choose from:

    Boolean

    Float

    Integer

    String

    Pathname

    List

    Input Column

    Output Column

    If you choose Input Column or Output Column, when the stage is included in a job a drop-down list will offer a choice of the defined input or output columns.

    If you choose list you should open the Extended Properties dialog box from the grid shortcut menu to specify what appears in the list.

  • Prompt is the name of the property that will be displayed on the Properties tab of the stage editor.
  • Default Value is the value the option will take if no other is specified.
  • Required. Set this to True if the property is mandatory.
  • Conversion specifies the type of property as follows:

    -Name. The name of the property will be passed to the operator as the option value. This will normally be a hidden property, that is, not visible in the stage editor.

    -Name Value. The name of the property will be passed to the operator as the option name, and any value specified in the stage editor is passed as the value.

    -Value. The value for the property specified in the stage editor is passed to the operator as the option name. Typically used to group operator options that are mutually exclusive.

    Value only. The value for the property specified in the stage editor is passed as it is.