Instead of entering the options on the command line, you may specify any of them in a job variables file.
Execute the following procedure from a Teradata client configured with Teradata PT.
- 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
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 text file. If you are not executing the tdload command in the directory where the job variables file is stored, you will need to specify the fully qualified file name of the job variables file in the -j option when executing tdload. Easy Loader supports job variables files saved as ASCII, UTF-8, and UTF-16, both with and without a UTF byte order mark.
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