Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 01 Mar 2007 @ 21:17:00 GMT


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


Subj:   Re: Multiple record types using mload
 
From:   Kopuuravuri, Ramu

Hi

I check with this sample Mload script..

     .logtable DB.test;
     .logon sd/u_name,xxxxxx;
     DATABASE DB;
     .BEGIN IMPORT MLOAD
       TABLES DB.test1,DB.test2
           ERRLIMIT 1000
           CHECKPOINT 0
           TENACITY 2
           SESSIONS 8
           SLEEP 6;
     .LAYOUT test_LAYOUT;
           .FILLER IN_Indicator                        1 VARCHAR(3);
           .FIELD IN_b_a                               3 VARCHAR(2);
           .FIELD IN_c_a                               * VARCHAR(3);

           .FIELD IN_b_b                               3 VARCHAR(3);
           .FIELD IN_c_b                               * VARCHAR(2);

     .DML LABEL INS_test1;
     INSERT INTO test1
           (
            a
           ,b
           ,c
            ) VALUES (
            'A'
           ,:IN_b_a
           ,:IN_c_a
     );

     .DML LABEL INS_test2;
     INSERT INTO test2
           (
            a
           ,b
           ,c
            ) VALUES (
            'B'
           ,:IN_b_b
           ,:IN_c_b
     );

     .IMPORT INFILE /home/a18a9/test_mul.txt
           LAYOUT test_LAYOUT
           FORMAT VARTEXT '|'
           APPLY INS_test1 WHERE IN_Indicator='A'
           APPLY INS_test2 WHERE IN_Indicator='B';

     .END MLOAD;
     .LOGOFF;

Sample data :

     A|aa|aaa
     B|aAa|aa

I got this error:

     **** 15:05:50 UTY4017 Not enough data in vartext record number 1.
     **** 15:05:50 UTY1803 Import processing statistics
          .                                       IMPORT  1     Total thus far
          .                                       ----------------------------
          Candidate records considered:........           0.......0
          Apply conditions satisfied:..........           0.......0
          Candidate records not applied:.......           0.......0
          Candidate records rejected:..........           0.......0

I change the FIELD position to 1,2 and 3.. but I got same error.

Can u pls guide me where is the mistake is happened.


Thanks in advance,

Ramu.



     
  <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: 28 Jun 2020