- PowerCenter 10.4.0
- All Products
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 of the variable. You can select from the following datatypes:
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 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:
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.
Whether the default value of the variable is null. If the default value is null, enable this option.
Description associated with the variable.