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 database 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 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.
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