Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 23 Jan 2008 @ 13:53:47 GMT

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

Subj:   Re: Loading a numeric with format like ZZZ.ZZZ.ZZZ,ZZ
From:   william.gregg

I recall many, many moons ago operating on each digit of the input attribute via a case statement that built up the number as the sum of pos1 * 100,000,000 + pos2 * 10,000,000 etc. The case statement assigned zero to null columns.

If you have leading zeros then the need for a case statement went away.

I also recall using a REDEFINES statement or its equivalent in the MLoad Script to put everything together as one named variable.

Does this ring true?


Bill Gregg

  <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