Task 1: Define a Job Variables File
Instead of entering the options on the command line, you may specify any of them in a job variables file.
Note: The following procedure assumes you have not yet created a job variables file. If you have, you can simply add job variables to it. A job variables file can contain job variables that multiple Teradata PT scripts use.
Execute the following procedure from a Teradata client configured with Teradata PT.
Procedure
1 Use a text editor to create a job variables file that contains a list of options and their corresponding values to be used with Teradata PT Easy Loader. Each job variable must be defined on a single line separated by commas, using the following format:
option = value
where:
Syntax Element |
Explanation |
option |
A single-letter or a multi-letter (long) option. Note: The option name is case-sensitive. |
value |
An integer or a character string. You must enclose character strings within single quotes. |
2 Save the job variables file as a .txt file in the same directory as your data file. If you save the job variables file in a different directory, you will need to specify the full file name of the job variables file in the -j option when executing tdload.
Example
The following shows the contents of a sample job variables file for a Teradata PT Easy Loader job.
SourceFileName = 'employee_data.txt',
u = 'dbadmin',
TargetUserPassword = 'tdpasswd5',
h = 'tdat1',
TargetWorkingDatabase = 'Tables_Database',
TargetTable = 'Employee',
SourceTextDelimiter = '|',
TargetMaxSessions = 6