Archives of the TeradataForum

Message Posted: Thu, 08 Dec 2005 @ 14:54:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, December 08, 2005 09:36 -->

I am attempting to use the Fastload utility (FASTLOAD UTILITY VERSION 07.06.00.000 PLATFORM WIN32) to load info from a .txt file to a table within Teradata. I have no problems using the code below to load a mainframe sequential file into a table.

I am receiving an error that I do not know how to resolve. I have been told that it is not possible to do what I am attempting to do:

"I was told it doesn't work with text. To get around it, load the text into SQL server using DTS and then load the data to Teradata using fastload from SQL server. "

It is difficult for me to believe that we cannot perform this operation, and have to use SQL Server to accomplish this task.

I have included some info from the log file, and hopefully someone can tell me what I am doing wrong.

     0007 CREATE TABLE P6_ADHO_TBLS.LEADFOOT ,FALLBACK

     ,NO BEFORE JOURNAL

     ,NO AFTER JOURNAL
             (H1_ACCT     INTEGER FORMAT '999999999',
              BASEINC1     CHAR(10),
              BASEINC2     CHAR(10),
              BASEINC3     CHAR(10))

             PRIMARY INDEX (H1_ACCT);

     **** 10:35:04 Command completed successfully


     0008 SET RECORD TEXT;

     **** 10:35:04 Now set to read 'TEXT' records
     **** 10:35:04 Command completed successfully


     0009    BEGIN LOADING P6_ADHO_TBLS.LEADFOOT
                ERRORFILES  P6_ADHO_TBLS.LEADFOOT_ERROR1,
                                            P6_ADHO_TBLS.LEADFOOT_ERROR2;

     **** 10:35:09 Number of AMPs available: 744
     **** 10:35:09 BEGIN LOADING COMPLETE


     0010 DEFINE
             H1_ACCT    (CHAR  (09)),
             BASEINC1   (CHAR  (10)),
             BASEINC2   (CHAR  (10)),
             BASEINC3   (CHAR  (10))
          /*   FILLER     (CHAR  (01)) */

          FILE=C:\DATAIN.TXT;

     **** 10:35:09 FDL4803 DEFINE statement processed


     0011 SHOW;

          FILE = C:\DATAIN.TXT
          H1_ACCT                          OFFSET =      0 LEN =     9 CHAR
          BASEINC1                         OFFSET =      9 LEN =    10 CHAR
          BASEINC2                         OFFSET =     19 LEN =    10 CHAR
          BASEINC3                         OFFSET =     29 LEN =    10 CHAR
          TOTAL RECORD LENGTH = 39


          -------------------------------------------------------------------
          -                                                                 -
          -          Insert Phase                                           -
          -                                                                 -
          -------------------------------------------------------------------

     0012 INSERT INTO P6_ADHO_TBLS.LEADFOOT
          VALUES
           (:H1_ACCT,:BASEINC1,:BASEINC2,:BASEINC3);

     **** 10:35:12 Number of recs/msg: 1460
     **** 10:35:12 Starting to send to RDBMS with record 1
     **** 10:35:12 I/O Error on File Read: 35, Text: EOF encountered before
                   end of record

	<Prev	Next>		<<First	<Prev	Next>	Last>>