Most Teradata PT job script values can be coded as job variables, which can be used anywhere in the script except within quoted strings and in comments. Once job variables have been defined, they can be reused multiple times within the associated job script. A common use of job variables is substituting the values for operator attributes.
If the attribute is:
Job variables can also be used as substitutes for object names and other job script parameters, but they cannot be used within quoted strings. The concatenation operator allows job variables to be used between quoted strings. For example, to substitute the job variable 'item' for the target table in an insert statement, use the string:
'Insert this'|| @item || ' into a column'
in the APPLY statement of the job script.
Using job variables for job script parameters requires completion of two setup activities:
Note: If values for a particular variable are stored in more than one of the above listed locations, the value of highest priority source is used.