Defining a Job Variables File for Easy Loader - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

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

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