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

Run the following Teradata PT job script:

DEFINE JOB qstart1
(
  APPLY $INSERT TO OPERATOR ($LOAD)
  SELECT * FROM OPERATOR($FILE_READER);
);

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

  1. To run the job script, execute the following Teradata PT command in the command window:
    tbuild -f qstart1.txt -v jobvars1.txt -j qstart1

    where the following is true:

    -f
    The name of the script to be run: qstart1.txt.
    -v
    The name of the job variables file: jobvars1.txt.
    This is the job variables file you have edited
    -j
    The name of the job: qstart1.

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 Version 17.10.00.00
Job log: C:\Program Files\Teradata\Client\17.10\Teradata Parallel Transporter\logs\qstart1-32.out
Job id is qstart1-3, running on WUSLK121545-V5X
Teradata Parallel Transporter DataConnector Operator Version 17.10.00.00
Teradata Parallel Transporter Load Operator Version 17.10.00.00
$LOAD: private log specified: loadprivate.log
$FILE_READER: TPT19008 DataConnector Producer operator Instances: 1
$FILE_READER: TPT19003 ECI operator ID: $FILE_READER-6024
$FILE_READER: TPT19222 Operator instance 1 processing file 'flatfile1.dat'.
$LOAD: connecting sessions
$LOAD: preparing target table
$LOAD: entering Acquisition Phase
$LOAD: entering Application Phase
$LOAD: Statistics for Target Table:  'TARGET_EMP_TABLE'
$LOAD: Total Rows Sent To RDBMS:      10
$LOAD: Total Rows Applied:            10
$FILE_READER: TPT19221 Total files processed: 1.
$LOAD: disconnecting sessions
$LOAD: Total processor time used = '0.078789 Second(s)'
$LOAD: Start : Mon Sep 18 23:06:53 2017
$LOAD: End   : Mon Sep 18 23:07:02 2017
Job step MAIN_STEP completed successfully
Job qstart1 completed successfully