16.20 - Defining a Job Variables File for Easy Loader - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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

  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