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