You can create job variables and assign job variable values in two types of files:
Note: A global job variables file is available on UNIX and Windows systems.
tbuild -f weekly_update.txt -v jobvars.txt
Note: On z/OS, specify a local job variables file through the DDNAME of ATTRFILE.
If possible, define known common job variables when you begin to employ Teradata PT. The use of job variables enhances the efficiency and security of job scripting. You can add additional job variable names and values when required.
Setting up variables requires two actions:
@<job variable name>
, as follows:
VARCHAR TdpId = @MyTdpId,
VARCHAR UserName = @MyUserName,
VARCHAR UserPassword = @MyUserPassword
<job variable name>=’value’
, as follows:
MyTdpId ='database1',
MyUserName ='johndoe',
MyUserPassword ='johndoe'
The location of the global job variables file and the local job variables file, as well as the name of the global and local job variables file, is user-definable in the context of the following:
GlobalAttributeFile = '<userspath>/<usersGlobalJobVariablesName>'
For further information on specifying job variables in the script “Setting Up Job Variables” on page 47.
For information on specifying job variables on the command line at job launch “Assigning Job Variables on the Command Line” on page 141.