FastLoad Error

Tools

FastLoad Error

Hello All,

In the below scripts FILE, i have exported the data using TEXT format converting the DEFINE To CHAR.

FastLoad Script:

.LOGTABLE DB.Logs;

.LOGON 127.0.0.1/jugal,jugal;

 

DROP TABLE DB.NewTab2;

DROP TABLE DB.FL_Err1;

DROP TABLE DB.FL_Err2;

create table DB.NewTab2

(

EmpId INT,

EmpName Char(10),

DeptId Varchar(10)

);

 

BEGIN LOADING DB.NewTab2

ERRORFILES DB.FL_Err1,

DB.FL_Err2

INDICATORS;

SET RECORD TEXT;

DEFINE in_EmpId (Char(15)),

in_EmpName (Char(15)),

in_DeptId (Char(15))

FILE=/home/jugal/Samples_FE_IND_TEXT.txt;

INSERT INTO DB.NewTab2 VALUES(:in_EmpId,:in_EmpName,:in_DeptId);

END LOADING;

LOGOFF;

 Logs:

$ fastload < /home/jugal/FL_Binary.txt

     ===================================================================

     =                                                                 =

     =          FASTLOAD UTILITY     VERSION 14.00.00.07               =

     =          PLATFORM LINUX                                         =

     =                                                                 =

     ===================================================================

     ===================================================================

     =                                                                 =

     =          Copyright 1984-2012, Teradata Corporation.             =

     =          ALL RIGHTS RESERVED.                                   =

     =                                                                 =

     ===================================================================

**** 14:31:11 Processing starting at: Mon May 12 14:31:11 2014

0001 .LOGTABLE DB.Logs;

**** 14:31:11 FDL4800 Invalid FastLoad statement

     ===================================================================

     =                                                                 =

     =          Logon/Connection                                       =

     =                                                                 =

     ===================================================================

0002 .LOGON edwdev.prod.fedex.com/jb956714,

**** 14:31:11 Teradata Database Release: 14.00.05.06

**** 14:31:11 Teradata Database Version: 14.00.05.07

**** 14:31:11 Number of AMPs available: 96

**** 14:31:11 Current CLI or RDBMS allows maximum row size: 64K

**** 14:31:11 Character set for this job: ASCII

0003 DROP TABLE DB.NewTab2;

**** 14:31:12 Command completed successfully

0004 DROP TABLE DB.FL_Err1;

**** 14:31:12 Command completed successfully

0005 DROP TABLE DB.FL_Err2;

**** 14:31:12 Command completed successfully

0006 create table DB.NewTab2

     (

     EmpId INT,

     EmpName Char(10),

     DeptId Varchar(10)

     );

**** 14:31:12 Command completed successfully

0007 BEGIN LOADING DB.NewTab2

     ERRORFILES DB.FL_Err1,

           DB.FL_Err2

     INDICATORS;

**** 14:31:12 Indicator mode is set to ON

**** 14:31:12 Session count 16 returned by the DBS overrides

              user-requested session count

**** 14:31:15 Number of FastLoad sessions connected = 16

**** 14:31:15 FDL4808 LOGON successful

**** 14:31:16 Number of AMPs available: 96

**** 14:31:16 BEGIN LOADING COMPLETE

0008 SET RECORD TEXT;

**** 14:31:16 Now set to read 'TEXT' records

**** 14:31:16 Command completed successfully

0009 DEFINE   in_EmpId (Char(15)),

         in_EmpName (Char(15)),

         in_DeptId (Char(15))

     FILE=/home/jugal/Samples_FE_IND_TEXT.txt;

**** 14:31:16 FDL4803 DEFINE statement processed

     ===================================================================

     =                                                                 =

     =          Insert Phase                                           =

     =                                                                 =

     ===================================================================

0010 INSERT INTO DB.NewTab2 VALUES(:in_EmpId,:in_EmpName,:in_DeptId);

**** 14:31:16 I/O Error on File Checkpoint: 42, Text: Unable to obtain

              data signature !ERROR! EOF encountered before end of

              record

     ===================================================================

     =                                                                 =

     =          Logoff/Disconnect                                      =

     =                                                                 =

     ===================================================================

**** 14:31:16 Logging off all sessions

**** 14:31:17 Total processor time used = '1.88 Seconds'

     .        Start : Mon May 12 14:31:11 2014

     .        End   : Mon May 12 14:31:17 2014

     .        Highest return code encountered = '12'.

**** 14:31:17 FastLoad Paused

Tags (1)
1 REPLY
Teradata Employee

Re: FastLoad Error

The TEXT format is for character/text data.

That data normally does not have indicator bytes (just an observation of your BEGIN LOADING statement).

However, the issue is most likely that you do not have an end-of-record marker (cr/lf) at the end of your data record (usually, the last record).

-- SteveF