The following is an example of the job’s output:
===================================================================
= =
= TERADATA PARALLEL TRANSPORTER =
= =
= ERROR TABLE EXTRACTION VERSION 16.10.00.00 =
= =
= COPYRIGHT 2014, TERADATA CORPORATION. ALL RIGHTS RESERVED. =
= =
===================================================================
**** 13:04:26 Processing starting at: Fri Feb 22 13:04:26 2016
===================================================================
= =
= Module Identification =
= =
===================================================================
ERROR TABLE EXTRACTOR for Linux release 2.6.16.60-0.91.TDC.1.R.2-smp
on machine
ErtblMain : 16.10.00.01
ErtblCLI : 16.10.00.03
ErtblMsgs : 16.10.00.01
ErtblUtil : 16.10.00.02
PXICU : 16.10.00.00
TDICU : 16.10.00.00
USelDir : 16.10.00.00
CLIv2 : 16.10.00.00
===================================================================
= =
= Command Line Argument Information =
= =
===================================================================
**** 13:04:26 The user specified the following command line arguments:
-h tdpid -u user -p <not displayable> -t SAMPLE_ERRTABLE1 -n 10
===================================================================
= =
= Job Options =
= =
===================================================================
**** 13:04:26 Options in effect for this job:
Output file: 'SAMPLE_ERRTABLE1.txt'
Output limit: No limit in effect
Record format: 'DELIMITED'
Text delimiter: '|'
Quoted fields: 'N' (Y for Yes, N for No)
===================================================================
= =
= Session Connection =
= =
===================================================================
Connecting to RDBMS: 'tdpid'
Connecting with UserId: 'user'
Session character set: 'ASCII'
**** 13:04:26 Connecting a session
**** 13:04:27 Session connected
===================================================================
= =
= Teradata Database Information =
= =
===================================================================
**** 13:04:27 Teradata Database Version: '16.10.00.00 '
**** 13:04:27 Teradata Database Release: '16.10.00.00 '
===================================================================
= =
= Error Table Information =
= =
===================================================================
Error table: 'SAMPLE_ERRTABLE1'
Number of columns sent to RDBMS in the original load job: 10
**** 13:04:27 The error table is a FastLoad protocol error table
**** 13:04:27 The endianness of the error data in the error table is
little-endian
===================================================================
= =
= Selecting The Error Table =
= =
===================================================================
**** 13:04:27 This job is submitting the following request:
SELECT CAST(ERRORFIELDNAME AS VARCHAR(128)),CAST(ERRORCODE AS
VARCHAR(10)),DATAPARCEL FROM SAMPLE_ERRTABLE1 ORDER BY ERRORCODE;
**** 13:04:27 The request has been completed
**** 13:04:27 Number of row(s) returned: 40
**** 13:04:27 Starting to retrieve data from the RDBMS
**** 13:04:27 Finished retrieving data
**** 13:04:27 Number of row(s) writtten to the output file: 40
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 13:04:27 Disconnecting session
**** 13:04:27 Session disconnected
**** 13:04:27 Total processor time used = '0.06 Second(s)'
. Start : Fri Jul 15 13:04:26 2016
. End : Fri Jul 15 13:04:27 2016
. Highest return code encountered = '0'.
**** 13:04:27 This job terminated
The output sample above is for example purposes only. Your output will be different.