Search found 61 matches
- Wed Aug 31, 2011 10:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting a Numeric value into Varchar...
- Replies: 5
- Views: 2769
converting a Numeric value into Varchar...
Hi i have the data for a column 'Amount' as following : The format for Column 'Amount' is -Numeric 15 8 1.00000000 2.00000000 3.00000000 now i want the output to be as following :-- Amount 100000000 200000000 300000000 please tell What is the modification i got to do in either the SQl or in DS.