Archives of the TeradataForum
Message Posted: Fri, 03 Sep 2004 @ 12:57:27 GMT
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) );
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 );
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|