Run the Teradata PT Job Script - Parallel Transporter

Teradata® Parallel Transporter Quick Start Guide

Product
Parallel Transporter
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
asf1608578451060.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2501
lifecycle
previous
Product Category
Teradata Tools and Utilities
You will be running the following is the Teradata PT job script:
DEFINE JOB qstart2
(
  APPLY TO OPERATOR ($FILE_WRITER)
  SELECT * FROM OPERATOR($EXPORT);
);

The script is saved as qstart2.txt in the quickstart sample directory.

  • To run the job script, execute the following Teradata PT command in the command window:
    tbuild -f qstart2.txt -v jobvars2.txt -j qstart2

    where the following is true:

    -f
    The name of the script to be run: qstart2.txt.
    -v
    The name of the job variables file: jobvars2.txt.
    This is the job variables file you have edited.
    -j
    The name of the job: qstart2.
Once you have run the tbuild command loading data into the target table, you will see the following output on the console, confirming that 10 rows have been loaded. The console output may contain a DBS 3807 warning. You can ignore this message. For more information, see the ErrorList operator attribute in the DDL Operator section of the Teradata Parallel Transporter Reference (B035-2436).
...
Teradata Parallel Transporter DataConnector Version 16.20.00.00
$FILE_WRITER: TPT19007 DataConnector Consumer operator Instances: 1
$FILE_WRITER: TPT19003 ECI operator ID: $FILE_WRITER-7992
$FILE_WRITER: TPT19222 Operator instance 1 processing file
'flatfile2.dat'.
Teradata Parallel Transporter Export Operator Version 16.20.00.00
$EXPORT: private log specified: exportprivate.log
$EXPORT: connecting sessions
$EXPORT: sending SELECT request
$EXPORT: entering End Export Phase
$EXPORT: Total Rows Exported: 10
$FILE_WRITER: TPT19221 Total files processed: 1.
$EXPORT: disconnecting sessions
$EXPORT: Total processor time used = '0.068708 Second(s)'
$EXPORT: Start : Tue Jul 19 02:28:57 2016
$EXPORT: End   : Tue Jul 19 02:29:03 2016
Job step MAIN_STEP completed successfully
Job lk121545 completed successfully