Decimal to String Conversion
Posted: Mon Sep 12, 2005 7:53 am
Hii,
I have 3 decimal fields and all other are char fields.When i view it in unix it give garbage in all decimal field and other char fields are fine.When I view the file in Datastage Sequential File Stage I view all the records properly.I think the problem is in Decimal fields,So i put the DecimaltoString Convertor in the transformer.But then it fills all zeros in the decimal field and shows blank space when viewed in VI Editor.
Please tell me how to implement it So i conver Decimalto String without loosing Data.
Input is Decimal[15,2].Output can be a string of any length.
I have 3 decimal fields and all other are char fields.When i view it in unix it give garbage in all decimal field and other char fields are fine.When I view the file in Datastage Sequential File Stage I view all the records properly.I think the problem is in Decimal fields,So i put the DecimaltoString Convertor in the transformer.But then it fills all zeros in the decimal field and shows blank space when viewed in VI Editor.
Please tell me how to implement it So i conver Decimalto String without loosing Data.
Input is Decimal[15,2].Output can be a string of any length.