Creating and using parameter sets in DataStage

You can create and use parameter sets in DataStage®.

Creating a parameter set

To create a parameter set to collect multiple job parameters with specified values to reuse in DataStage flows:
  1. Open an existing project or create a project.
  2. Click New Asset + and select Define reusable sets of parameters.
  3. Enter a name and description, then click Create. The Parameter set page opens.
  4. Add parameters.
    1. Click the Parameters tab.
    2. Enter the following information:
      Name
      The name of the parameter.
      Type
      The type of parameter that you are creating, which can be one of the following values:
      Parameter type Description
      Date Used to specify the date in the format yyyy-mm-dd.
      Encrypted Used to specify a password.
      List Used to specify enumerated data types.
      Integer Used to specify a long integer. This value can be -2147483648 up to 2147483647.
      Path Used to specify a path name or file name.
      String Used to specify a text string.
      Float Used to specify a single float.
      Time Used to specify the time in the format hh:mm:ss.
      Timestamp Used to specify the timestamp. The format options of timestamp combine the formats of data and time data types. The default timestamp format is: %yyyy-%mm-%dd %hh:%mm:%ss
      Multiline string Used to specify the value that is a long string, such as an SSL certificate or an SQL statement. The input field is a text area.
      Email Used to specify the persisting email address. Only a valid email address can be specified for an email type. The input field is a text area.
      Vaulted secret Used to specify parameter values that point to a secret in the vault. At runtime, the value of the secret is securely retrieved from the vault. This parameter is not available for public cloud environments.
      Prompt
      The text that displays for this parameter when you run the job.
      Default value
      The default value for the parameter, such as a directory path.
    3. Click Create.
  5. Add value sets for the parameters:
    1. Click the Value sets tab. Then, click Create value set.
    2. Enter a name, then modify the default value of each parameter set to a new value.
    3. Click Save.

You can view all your parameter sets by opening the Assets tab and clicking Configurations.

Adding a parameter set to your DataStage flow

To add a parameter set to your DataStage flow:

  1. Open the DataStage flow that you want to add parameter sets for, then click the Add parameters ({#}) icon.
  2. Click the Parameter sets tab, click Add parameter sets, then select the parameter set that you want to add to the DataStage flow. Then, click Add.

Using a parameter set in a stage or connector

To use a parameter set in a stage or connector:
  1. Open the DataStage flow, then open the stage or connector that you want to use a parameter set.
  2. In the Properties panel for the stage or connector, open the Properties section.
  3. Hover your mouse pointer near the end of a property field. If the Parameterize icon ({#}) appears, click the icon to show the Select a parameter page. The page shows all the local parameters and parameters that are from added parameter sets.
  4. Choose a parameter for the property.