Run the Teradata PT Job Script | Teradata Parallel Transporter Quick Start Guide - Run the Teradata PT Job Script - Parallel Transporter

Teradata® Parallel Transporter Quick Start Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2023-11-20
dita:mapPath
msi1691132563218.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
zyr1479309207403
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