Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 03 Sep 2004 @ 12:57:27 GMT


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


Subj:   Doing Concatenation/Substring in Fastload
 
From:   Czajkowski, Al (A.J.)

I'm writing a Fastload, and can't figure out how to either concatenate two input fields for loading into one column or how to take a substring of one field and put it into a column. Due to a wonder full business requirement, a portion of this data goes into two different columns..

     Define
     Full_Acct_Nb  (Char(26))
      DDNAME =INFILE;
     Insert into mdb.mytabl
       (Cust_Acct_Nb,
        Base_Acct_Nb)
     Values
       (
       :Full_Acct_Nb,
       substr(:full_acct_nb,13,14)
       );

or

     Define
     Prefix_Acct_Nb  (Char(12))
     Base_Acct_Nb  (Char(14))
      DDNAME =INFILE;
     Insert into mdb.mytabl
       (Cust_Acct_Nb,
        Base_Acct_Nb)
     Values
       (
       :Prefix_Acct_Nb||:Base_Acct_Nb,
       :Base_acct_nb
       );

Electronically,

Al Czajkowski



     
  <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