Compress Functionality..help needed

amitaguptain · Post by **amitaguptain** » Fri Jun 15, 2007 4:49 am

Hi,

I have feild in datastage with datatype decimal(9,3) and the values atre like
000000.000
000002.000
000003.100
We want to get rid of these laeding and trailing Zeroes.and the final output we want as
0
2
3.1
Can You tell which function to use or how to achieve this??

thanks in Advance,
Amita

JoshGeorge · Post by **JoshGeorge** » Fri Jun 15, 2007 5:22 am

Depends on what your output stage is. If seq. file is where you are writing your data, represent the same column as Real(9,3).

amitaguptain · Post by **amitaguptain** » Fri Jun 15, 2007 5:38 am

JoshGeorge wrote:Depends on what your output stage is. If seq. file is where you are writing your data, represent the same column as Real(9,3).

After using this approach,when we view the file in unix,it shows the output in Xponent form.which we dont want

JoshGeorge · Post by **JoshGeorge** » Fri Jun 15, 2007 6:11 am

If you 'all' want something specific, pls. post your requirement also in detail. In which stage you want to convert, if you want this in the output are you writing this into a seq. stage as .txt?

which we dont want

amitaguptain · Post by **amitaguptain** » Fri Jun 15, 2007 6:32 am

Yes we are writting our output in the Seq Stage at .txt file.
In DataStage if we do view data it shows output as expected but if we go to unix and view the same file,it is in the exponent form.
Even in unix can we get the recods in the expected format??

Ultramundane · Post by **Ultramundane** » Fri Jun 15, 2007 7:58 am

amitaguptain wrote: Even in unix can we get the recods in the expected format??

We? I can do it, but I don't know if this is the best way.

Send your output to an external target stage and use the program awk and multiply by the identity in base 10.