Archives of the TeradataForum

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

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

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>>