Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Creating User-Defined Workflow Variables

Creating User-Defined Workflow Variables

You can create workflow variables for a workflow in the workflow properties.
To create a workflow variable:
  1. In the Workflow Designer, create a new workflow or edit an existing one.
  2. Select the Variables tab.
  3. Click Add.
  4. Enter the information in the following table and click OK:
    Field
    Description
    Name
    Variable name. The correct format is $$
    VariableName
    . Workflow variable names are not case sensitive.
    Do not use a single dollar sign ($) for a user-defined workflow variable. The single dollar sign is reserved for predefined workflow variables.
    Datatype
    Datatype of the variable. You can select from the following datatypes:
    • Date/Time
    • Double
    • Integer
    • Nstring
    Persistent
    Whether the variable is persistent. Enable this option if you want the value of the variable retained from one execution of the workflow to the next.
    Default Value
    Default value of the variable. The Integration Service uses this value for the variable during sessions if you do not set a value for the variable in the parameter file and there is no value stored in the repository.
    Variables of type Date/Time can have the following formats:
    • MM/DD/RR
    • MM/DD/YYYY
    • MM/DD/RR HH24:MI
    • MM/DD/YYYY HH24:MI
    • MM/DD/RR HH24:MI:SS
    • MM/DD/YYYY HH24:MI:SS
    • MM/DD/RR HH24:MI:SS.MS
    • MM/DD/YYYY HH24:MI:SS.MS
    • MM/DD/RR HH24:MI:SS.US
    • MM/DD/YYYY HH24:MI:SS.US
    • MM/DD/RR HH24:MI:SS.NS
    • MM/DD/YYYY HH24:MI:SS.NS
    You can use the following separators: dash (-), slash (/), backslash (\), colon (:), period (.), and space. The Integration Service ignores extra spaces. You cannot use one- or three-digit values for year or the “HH12” format for hour.
    Variables of type Nstring can have a maximum length of 600 characters.
    Is Null
    Whether the default value of the variable is null. If the default value is null, enable this option.
    Description
    Description associated with the variable.
  5. To validate the default value of the new workflow variable, click the Validate button.
  6. Click Apply to save the new workflow variable.
  7. Click OK.


Updated June 03, 2019