Run the Teradata PT Job Script
The following is the Teradata PT job script you will be running.
The script is saved as qstart3.txt in the quickstart sample directory.
DEFINE JOB qstart3
APPLY $INSERT TO OPERATOR ($UPDATE)
SELECT * FROM OPERATOR ($EXPORT);
To run the job script, execute the following Teradata PT command in the command window:
tbuild -f qstart3.txt -v jobvars3.txt -j qstart3
This tbuild option...
Takes the following argument...
Name of the script to be run: qstart3.txt
Name of the job variables file: jobvars3.txt
This is the job variables file you have edited.
Name of the job: qstart3
RESULT: 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 chapter of the Teradata Parallel Transporter Reference.
. . .
Teradata Parallel Transporter Version 15.00.00.00
Job log: C:\Program Files\Teradata\client\15.00.00\Teradata Parallel Transporter/lo
Job id is qstart3-36, running on WUSLK121545-V5X
Teradata Parallel Transporter Update Operator Version 15.00.00.00
$UPDATE: private log specified: updateprivate.log
Teradata Parallel Transporter Export Operator Version 15.00.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.171601 Second(s)'
$EXPORT: Start : Fri May 20 14:01:36 2011
$EXPORT: End : Fri May 20 14:01:48 2011
$UPDATE: Total processor time used = '0.171601 Second(s)'
$UPDATE: Start : Fri May 20 14:01:36 2011
$UPDATE: End : Fri May 20 14:01:49 2011
Job step MAIN_STEP completed successfully
Job qstart3 completed successfully