Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Jan 2006 @ 14:20:06 GMT


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


Subj:   Re: Help required with Mload!
 
From:   Jay.Munshi

Hi Jason,

Thanks a Million for responding.

You are right, the table creation was not the error. I atleast could get a record in there.

Now making the slightly to resemble the real life scenario I am trying to import the following content

     21|Creighton Bryden|5000
     1|Rudolph Cheng|5000
     3|Steve Willis|2000
     4|Cyril Soga| 15000
     5|Irene Bright|1000

With the following script.

     .Logtable Logtable003;
     .Logon dbc/sdm,sdm;
     create table emp (empno integer format '9(2)',Ename varchar(20),sal
     integer format '9(5)');
     .Begin Import mload tables Emp;
     .Layout Layoutname;
     .Field Empno 1 varchar(2);
     .Field Ename 2 varchar(20);
     .Field Sal 3 varchar(5);
     .DML Label inslbl;
     insert into emp.*;
     .Import Infile c:\multiload\insert.input
     format vartext '|'
     Layout LayoutName
     Apply inslbl;
     .End Mload;
     .Logoff;

Following are the details of the tables created during the load.

     select * from et_emp;

     select * from et_emp;
     $
      *** Failure 3798 A column or character expression is larger than the max size.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     select * from logtable003
     ;

     select * from logtable003
     ;

      *** Query completed. 5 rows found. 22 columns returned.
      *** Total elapsed time was 1 second.

         LogType         Seq       ReqRC     ReqType      ReqLen ReqMsg
     ----------- ----------- ----------- ----------- ----------- --------
             130           1           ?           ?           ? ?
               0           ?           ?           ?           ? ?
               1           1           0           6          92 ?
             130           1           ?           ?           ? ?
             110           1           ?           ?           ? ?

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     select * from uv_emp;

     select * from uv_emp;

      *** Query completed. No rows found.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     select * from wt_emp;

     select * from wt_emp;

      *** Query completed. No rows found.
      *** Total elapsed time was 1 second.

Following is the logfile:

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Utility    Release MLOD.07.07.01.000              =
     =          Platform WIN32                                              =
     =                                                                      =
     ------------------------------------------------------------------------
     =                                                                      =
     =          Copyright 1990-2005, NCR Corporation. ALL RIGHTS RESERVED.  =
     =                                                                      =
     ------------------------------------------------------------------------

     **** 19:29:25 UTY2411 Processing start date: WED JAN 04, 2006

     ------------------------------------------------------------------------
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ------------------------------------------------------------------------
     0001 .Logtable Logtable003;
     0002 .Logon dbc/sdm,;
     **** 19:29:27 UTY8400 Default character set: ASCII

     **** 19:29:27 UTY8400 Current RDBMS has interval support
     **** 19:29:27 UTY8400 Maximum supported buffer size: 1M
     **** 19:29:27 UTY8400 Data Encryption supported by RDBMS server
     **** 19:29:28 UTY6211 A successful connect was made to the RDBMS.
     **** 19:29:28 UTY6217 Logtable 'SDM.Logtable003' has been created.

     ------------------------------------------------------------------------
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ------------------------------------------------------------------------
     0003 create table emp (empno integer format '9(2)',Ename varchar(20),sal integer
          format '9(5)');
     **** 19:29:29 UTY1016 'CREATE' request successful.
     0004 .Begin Import mload tables Emp;

     ------------------------------------------------------------------------
     =                                                                      =
     =          Processing MultiLoad Statements                             =
     =                                                                      =
     ------------------------------------------------------------------------
     0005 .Layout Layoutname;
     0006 .Field Empno 1 varchar(2);
     0007 .Field Ename 2 varchar(20);
     0008 .Field Sal 3 varchar(5);
     0009 .DML Label inslbl;
     0010 insert into emp.*;
     0011 .Import Infile c:\multiload\insert.input
          format vartext '|'
          Layout LayoutName
          Apply inslbl;
     0012 .End Mload;

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Initial Phase                                     =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 19:29:29 UTY0829 Options in effect for this MultiLoad import task:
          .       Sessions:    One session per available amp.
          .       Checkpoint:  15 minute(s).
          .       Tenacity:    4 hour limit to successfully connect load sessions.
          .       Errlimit:    No limit in effect.
          .       AmpCheck:    In effect for apply phase transitions.
     **** 19:29:29 UTY0817 MultiLoad submitting the following request:
          Select NULL from SDM.Logtable003 where (LogType = 125) and (Seq = 1) and
          (MloadSeq = 0);
     **** 19:29:29 UTY0817 MultiLoad submitting the following request:
          Select NULL from SDM.Logtable003 where (LogType = 120) and (Seq = 1);
     **** 19:29:30 UTY0815 MLOAD session(s) connected: 2.
     **** 19:29:30 UTY0817 MultiLoad submitting the following request:
          BEGIN MLOAD Emp WITH INTERVAL;
     **** 19:29:30 UTY0817 MultiLoad submitting the following request:
          INS SDM.Logtable003 (LogType, Seq, MLoadSeq)VALUES(130, 1, 10);
     **** 19:29:30 UTY0817 MultiLoad submitting the following request:
          MLOAD Emp with WT_Emp errortables ET_Emp, UV_Emp;

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad DML Transaction Phase                             =
     ------------------------------------------------------------------------
     **** 19:29:31 UTY0817 MultiLoad submitting the following request:
          BT;
     **** 19:29:31 UTY0817 MultiLoad submitting the following request:
          USING EMPNO(VARCHAR(2)), ENAME(VARCHAR(20)), SAL(VARCHAR(5)) insert into
          emp
          VALUES(:empno, :Ename, :sal);
     **** 19:29:31 UTY0817 MultiLoad submitting the following request:
          INS SDM.Logtable003 (LogType, Seq, MLoadSeq)VALUES(130, 1, 20);
     **** 19:29:31 UTY0817 MultiLoad submitting the following request:
          ET;

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Acquisition Phase                                 =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 19:29:31 UTY0817 MultiLoad submitting the following request:
          BEGIN TRANSACTION;
     **** 19:29:31 UTY0817 MultiLoad submitting the following request:
          CHECKPOINT LOADING INTERVAL 0;
     **** 19:29:31 UTY0817 MultiLoad submitting the following request:
          CHECKPOINT LOADING INTERVAL 0;
     **** 19:29:33 UTY0817 MultiLoad submitting the following request:
          CHECKPOINT LOADING INTERVAL 0;
     **** 19:29:34 UTY0817 MultiLoad submitting the following request:
          USING Ckpt(VARBYTE(1024)) INSERT SDM.Logtable003  (Logtype, Seq, MLoadSeq,
          MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4,
          MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,MLoadCkpt) VALUES (110, 1,
          0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, :Ckpt);
     **** 19:29:34 UTY4203 Attempted to access out of range input data in field 'ENAME', file
          'c:\multiload\insert.input',record number '1'.
     **** 19:29:34 UTY1803 Import processing statistics
          .                                       IMPORT  1     Total thus far
          .                                       =========     ==============
          Candidate records considered:........           1.......1
          Apply conditions satisfied:..........           0.......0
          Candidate records not applied:.......           0.......0
          Candidate records rejected:..........           0.......0

     ------------------------------------------------------------------------
     =                                                                      =
     =          Logoff/Disconnect                                           =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 19:29:35 UTY6212 A successful disconnect was made from the RDBMS.
     **** 19:29:35 UTY2410 Total processor time used = '0.421875 Seconds'
          .       Start : 19:29:25 - WED JAN 04, 2006
          .       End   : 19:29:35 - WED JAN 04, 2006
          .       Highest return code encountered = '12'.

Please help me identify the problem.


Thanking you in advance,

Jay Munshi



     
  <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: 23 Jun 2019