Archives of the TeradataForum
Message Posted: Wed, 23 Jan 2008 @ 13:53:47 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|