In the datastage help, for decimaltostring function it is given that,
Code: Select all
'fix_zero'
By default decimal numbers comprising all zeros are treated as invalid. If the string fix_zero is specified as a second argument, then all zero decimal values are regarded as valid.
For some records, i was getting 000.00 from the source which are being populated to the target(of varchar) without using the decimaltostring function..And they are being validated....
Is there any situation to use this function instead....