.
Moderators: chulett, rschirm, roy
Babbu, you didn't ask a question. Is this function not working, and if so, what output do you get? What is the data type of the resulting column? It it is still integer then remember, numeric columns have no leading zeroes, so you string function would create a valid string with leading zeroes, which would then get converted implicitly back to an integer.
</a>when i am using the above function iam getting the same output without any change
wat condition can i use to get the above output if function cant be used.
thanks
wat condition can i use to get the above output if function cant be used.
thanks
Last edited by babbu on Sun May 25, 2008 7:27 am, edited 1 time in total.
Hello Babbu, you don't seem to understand the concept - numbers (integer,real,decimals) are stored as binary values and there is no concept of leading zeroes or any other formatting. That comes about when the value is displayed or converted to a string.
In your example you created a nicely formatted string with leading zeroes which DataStage then converted back into a binary format. You need to change the formatting when outputting the number and cannot do it where you are currently attempting to do so.
In your example you created a nicely formatted string with leading zeroes which DataStage then converted back into a binary format. You need to change the formatting when outputting the number and cannot do it where you are currently attempting to do so.