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.
- 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.
- -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