Task 1: Define a Job Variables File - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Task 1: Define a Job Variables File

Instead of entering the options on the command line, you may specify any of them in a job variables file.

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

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.

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