Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 04 May 2001 @ 18:51:59 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Fastload Help
From:   Anomy Anom

<-- Anonymously Posted: Friday, May 04, 2001 14:45 -- >

I am running Fastload from a network-attached system. The input data is created by extracting data from Teradata tables using FOCUS. The process has been working fine until I removed a WHERE clause from my extract and the number of records went from 14,000 to 45,000. Eyeballing the file everything looks kosher with the data. But when I Fastload it, the Fastload runs without errors but the data is messed up in the table. I cannot figure out what is going on!

The version is FASTLOAD WORKSTATION 4.0.

Here is the Fastload script:

     Drop Table TESTDB01.BTEMPT;

     Drop Table TESTDB01.BERR1;
     Drop Table TESTDB01.BERR2;

     Create Table TESTDB01.BTEMPT, Fallback

     (FA       Char(11)        Uppercase,
      FZ       Char(11)        Uppercase,
      FD       Char(05)        Uppercase,
      FT       Char(06)        Uppercase,
      FL       Char(45)        Uppercase,
      DUEDT    Char(08));

     Begin Loading TESTDB01.BTEMPT

       Errorfiles  TESTDB01.BERR1,


     set record unformatted ;

     Define  FA        (Char(11)),
             FZ        (Char(11)),
             FD        (Char(05)),
             FT        (Char(06)),
             FL        (Char(45)),
             DUEDT     (Char(08),  NULLIF='        '),
             NEWLINE   (Char(01))


     Insert into TESTDB01.BTEMPT values

             (:FA, :FZ, :FD, :FT, :FL, :DUEDT);
     End Loading;



P.S. With a few modifications to the Fastload script, I ran the Fastload from MVS and the data loaded correctly.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020