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 qstart3
(
  APPLY $INSERT TO OPERATOR ($UPDATE)
  SELECT * FROM OPERATOR ($EXPORT);
);

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

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

    where the following is true:

    -f
    The name of the script to be run: qstart3.txt.
    -v
    The name of the job variables file: jobvars3.txt.
    This is the job variables file you have edited.
    -j
    The name of the job: qstart3.
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 written to a target table that already has 10 rows. 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/lo
gs/qstart3-36.out
Job id is qstart3-36, running on WUSLK121545-V5X
Teradata Parallel Transporter Update Operator Version 17.10.00.00
$UPDATE: private log specified: updateprivate.log
Teradata Parallel Transporter Export Operator Version 17.10.00.00
$EXPORT: private log specified: exportprivate.log
$UPDATE: connecting sessions
$EXPORT: connecting sessions
$UPDATE: preparing target table(s)
$UPDATE: entering DML Phase
$UPDATE: entering Acquisition Phase
$EXPORT: sending SELECT request
$EXPORT: entering End Export Phase
$EXPORT: Total Rows Exported: 10
$UPDATE: entering Application Phase
$UPDATE: Statistics for Target Table: 'TARGET_EMP_TABLE'
$UPDATE: Rows Inserted: 10
$UPDATE: Rows Updated: 0
$UPDATE: Rows Deleted: 0
$UPDATE: entering Cleanup Phase
$UPDATE: disconnecting sessions
$EXPORT: disconnecting sessions
$EXPORT: Total processor time used = '0.069233 Second(s)'
$EXPORT: Start : Tue Sep 19 02:37:48 2017
$EXPORT: End   : Tue Sep 19 02:38:18 2017
$UPDATE: Total processor time used = '0.065116 Second(s)'
$UPDATE: Start : Tue Sep 19 02:37:48 2017
$UPDATE: End   : Tue Sep 19 02:38:18 2017
Job step MAIN_STEP completed successfully
Job qstart3 completed successfully