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.