Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 May 2005 @ 19:45:18 GMT


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


Subj:   Fast load Script is getting paused
 
From:   Pratap Manubolu

Hi all,

i am working on a Fast load script to Load data from a text file "data.txt". I am getting the following problem. The Fast load is getting paused with return code 12, which is a fatal error. Can anybody tell me where i am going wrong??


Thanks

Pratap


     C:\PROGRA~1\NCR\TERADA~1\bin>fastload < fload_script
          -------------------------------------------------------------------
          -                                                                 -
          -          FASTLOAD UTILITY     VERSION 07.04.00                  -
          -                                                                 -
          -------------------------------------------------------------------

     **** 13:44:22 Processing starting at: Fri May 27 13:44:22 2005
     MOSI: Can't access C:\Documents and Settings\Pratap\Desktop - logging disabled
     **** 13:44:22 Character set has been set to: ASCII
     **** 13:44:22 Tenacity Enabled:  3 hour(s)
     **** 13:44:22 Sleep Minutes Set: 5 minute(s)
     **** 13:44:22 Buffer size has been set to 48 KBytes

     0001 SHOW VERSION;

          FastLoad Version 07.04.00 for Win 32 running Windows Sockets
          FastLoad  : 07.04.00.03
          FastCmds  : 07.04.00.06
          FastIO    : 07.04.00.01
          FastMBCS  : 07.04.00.03
          FastNtfy  : 07.02.00.01
          FastPars  : 07.04.00.01
          FastSQL   : 07.04.00.08
          FastUtil  : 07.04.00.02
          PMPROCS   : 01.04.00.03
          PMRWFMT   : 01.04.00.03
          PMTRCE    : 01.01.00.01
          PMMM      : 01.01.00.01
          PMHEXDMP  : 01.01.00.01
          PMUNXDSK  : 01.04.00.02
          CLIV2     : 04.06.00.08
          MTDP      : 04.06.00.05
          MOSIos    : 04.06.00.05
          MOSIDEP   : 04.06.00.01
          OSENCRYPT : N/A
          OSERR     : 04.05.00.00

          FastLoad linking date: Jun 20 2001


     0002 SESSION 2;

     **** 13:44:22 FDL4800 Invalid FastLoad statement

     0003 ERRLIMIT 25;

     **** 13:44:22 Error limit set to: 25

     -------------------------------------------------------------------
     -                                                                 -
     -          Logon/Connection                                       -
     -                                                                 -
     -------------------------------------------------------------------

     0004 LOGON teradata/pratap,

     **** 13:44:24 Current CLI or RDBMS allows maximum row size: 64K
     **** 13:44:24 Character set for this job: ASCII
     **** 13:44:27 Number of FastLoad sessions connected = 4
     **** 13:44:27 FDL4808 LOGON successful


     0005 DATABASE Fast;

     **** 13:44:27 Command completed successfully

     0006 Drop Table test;

     **** 13:44:29 Command completed successfully

     0007 drop table err_1;

     **** 13:44:30 Command completed successfully

     0008 drop table err_2;

     **** 13:44:31 Command completed successfully


     0009 CREATE TABLE TEST ( A char(2), B char(2), C char(2), D char(2), M integer);



     **** 13:44:35 Command completed successfully


     0010 set record unformatted;

     **** 13:44:35 Now set to read 'UNFORMATTED' records
     **** 13:44:35 Command completed successfully


     0011 define delim0(char(1)), A(char(2)),
                 delim1(char(1)), B(char(2)),
                 delim2(char(1)), C(char(2)),
                 delim3(char(1)), D(char(2)),
                 delim4(char(1)), M(char(2)),
                 newlinechar(char(1))

          file = Dataset.txt;

     **** 13:44:35 FDL4803 DEFINE statement processed


     0012 show;

          FILE = Dataset.txt
          DELIM0                           OFFSET =      0 LEN =     1 CHAR
          A                                OFFSET =      1 LEN =     2 CHAR
          DELIM1                           OFFSET =      3 LEN =     1 CHAR
          B                                OFFSET =      4 LEN =     2 CHAR
          DELIM2                           OFFSET =      6 LEN =     1 CHAR
          C                                OFFSET =      7 LEN =     2 CHAR
          DELIM3                           OFFSET =      9 LEN =     1 CHAR
          D                                OFFSET =     10 LEN =     2 CHAR
          DELIM4                           OFFSET =     12 LEN =     1 CHAR
          M                                OFFSET =     13 LEN =     2 CHAR
          NEWLINECHAR                      OFFSET =     15 LEN =     1 CHAR
          TOTAL RECORD LENGTH = 16


     0013 begin loading Fast.Test errorfiles err_1, err_2;

     **** 13:44:38 Number of AMPs available: 4
     **** 13:44:38 BEGIN LOADING COMPLETE


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

     0014 insert into Fast.Test (A,B,C,D,M) Values (:A,:B,:C,:D,:M);

     **** 13:44:38 Number of recs/msg: 2230
     **** 13:44:38 Starting to send to RDBMS with record 1
     **** 13:44:38 EOF encountered while processing record
                   Record: 60
                   Column: DELIM2
          -------------------------------------------------------------------
          -                                                                 -
          -          Logoff/Disconnect                                      -
          -                                                                 -
          -------------------------------------------------------------------

     **** 13:44:38 Logging off all sessions
     **** 13:44:39 Total processor time used = '0.109375 Seconds'
          .        Start : Fri May 27 13:44:22 2005
          .        End   : Fri May 27 13:44:39 2005
          .        Highest return code encountered = '12'.
     **** 13:44:39 FastLoad Paused

     C:\PROGRA~1\NCR\TERADA~1\bin>

Here is the Fast load script ....

Fload_script file:

     SHOW VERSION;
     SESSION 2;
     ERRLIMIT 25;
     LOGON teradata/pratap,password;

     DATABASE Fast;
     Drop Table test;
     drop table err_1;
     drop table err_2;

     CREATE TABLE TEST ( A char(2), B char(2), C char(2), D char(2), M integer);

     set record unformatted;

     define delim0(char(1)), A(char(2)),
            delim1(char(1)), B(char(2)),
            delim2(char(1)), C(char(2)),
            delim3(char(1)), D(char(2)),
            delim4(char(1)), M(char(2)),
            newlinechar(char(1))

     file = Dataset.txt;

     show;

     begin loading Fast.Test errorfiles err_1, err_2;

     insert into Fast.Test (A,B,C,D,M) Values (:A,:B,:C,:D,:M);
     end loading;
     logoff;

     A Sample Text File.....Data.txt


     Text File: (sample)

     |a2 |b3 |c3 |d1 |9
     |a4 |b3 |c3 |d1 |9
     |a4 |b3 |c4 |d2 |9
     |a3 |b1 |c2 |d1 |3
     |a2 |b1 |c4 |d2 |2
     |a3 |b1 |c2 |d2 |8


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