All Forums Tools
12 May 2014
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

feinholz 1234 posts Joined 05/08
12 May 2014

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

You must sign in to leave a comment.