Error when executing a Fastload script

Tools

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

1 REPLY
Supporter

Re: Error when executing a Fastload script

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

this seems to be odd.

Can you share the script and the whole log?