Run the Teradata PT Job Script
The following is the Teradata PT job script you will be running.
The script is saved as qstart2.txt in the quickstart sample directory.
DEFINE JOB qstart2
(
APPLY TO OPERATOR ($FILE_WRITER)
SELECT * FROM OPERATOR($EXPORT);
);
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:
|
This tbuild option... |
Takes the following argument... |
|
-f |
Name of the script to be run: qstart2.txt |
|
-v |
Name of the job variables file: jobvars2.txt This is the job variables file you have edited. |
|
-j |
Name of the job: qstart2 |
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 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 chapter of the Teradata Parallel Transporter Reference.
. . .
Teradata Parallel Transporter DataConnector Version 15.00.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 15.00.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.140401 Second(s)'
$EXPORT: Start : Fri Jun 03 12:55:50 2011
$EXPORT: End : Fri Jun 03 12:55:59 2011
Job step MAIN_STEP completed successfully
Job lk121545 completed successfully