All Forums Tools
Swathi4b2 1 post Joined 02/12
29 Feb 2012
Error when executing a Fastload script

I am trying to run a fastload script which will load data from tab delimited file to teradata table.

I have 100 records in the source flat file and all the 100 records are being loaded into target table. But the error code being returned is 8 and not 0.

The output looks something like this:

****************************************************** ***********************

**** 09:56:30 END LOADING COMPLETE

     Total Records Read              =  101
      - skipped by RECORD command    =  1
      - sent to the RDBMS            =  100
     Total Error Table 1             =  0  ---- Table has been dropped
     Total Error Table 2             =  0  ---- Table has been dropped
     Total Inserts Applied           =  100
     Total Duplicate Rows            =  0

     Start:   Wed Feb 29 09:56:30 2012
     End  :   Wed Feb 29 09:56:30 2012

**** 09:56:31 FDL4802 Already logged on
     ====================================================== =============
     =                                                                  =
     =          Logoff/Disconnect                                      =
     =                                                                  =
     ====================================================== =============

**** 09:56:31 Logging off all sessions
**** 09:56:37 Total processor time used = '1.33 Seconds'
     .        Start : Wed Feb 29 09:56:18 2012
     .        End   : Wed Feb 29 09:56:37 2012
     .        Highest return code encountered = '8'.
**** 09:56:37 FDL4818 FastLoad Terminated

 

****************************************************** ***********************

Can someone suggest why am I getting an error code 8??

ulrich 816 posts Joined 09/09
29 Feb 2012

**** 09:56:31 FDL4802 Already logged on

this seems to be odd.

Can you share the script and the whole log?

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.