Datastage.. I have a field which has the value say 59.0900..I want to convert it to 05909

1.5k Views Asked by At

I have a field which has the value say 59.0900..I want to convert it to 05909 Can somebody help me with that..Im working on datastage IBM infosphere

1

There are 1 best solutions below

0
On
  • Convert the field into String
  • Trim the trailing zeros and decimal point
  • convert back to Decimal or integer