Instead of entering the options on the command line, you may specify any of them in a job variables file.
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. Any attributes not supported as part of the allowed set of tdload command line options must be specified in the job variables file. Because tdload internally calls tbuild, these attributes get passed as part of the job variables file to the tbuild command.
Execute the following procedure from a Teradata client configured with Teradata PT.
Procedure
- 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. The option name is case-sensitive.value An integer or a character string. You must enclose character strings within single quotes.
- 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