DSXchange

Hi,
I am trying to remove the leading zeros in the decimal field in a sequential file stage.
for example...
if we have a value 000000000000000032.00
i want it to be changed as 32.00 .
please let me know if there is any way i can do it .
My input is a database and i am trying to put the data into a sequential file
THank you in advance

You will need to change the data type to Varchar. DataStage will always add leading and trailing nonsignificant zeroes to Decimal data type when writing to text file or displaying through data browser. This proves that precision and scale are being handled properly.

Even after converting into varchar...the leading zeros come up....is there any other way i cna get rid of the leading zeros

How exactly are you "converting into varchar"?

I hope this will solve your issue..
sAM

I observed that all posts related to this issue has the similar solution which says that we have to read the output as varchar and use DecimalToString in Transformer..

But when we were faces with this issue, one of my peers suggested using C_format option in the column properties...and it worked..Anyone here who disagrees?

Use DecimalToString() with "suppress_zero" option. Something like

EDIT: suppress should have two P's as mentioned by Ray.

Double "P" in "suppress".

Correct me if I'm wrong but cannot you use Integer type instead of decimal ?

Thanks Ray for correcting it.

you should only use it when the you don't have precision associated with the decimal value. Also integer datatype's storage (i think even bigint) may be insufficient to store decimal(38,0).

True, but maybe he could tell us how much he needs because 38 digits, man, that's a lot.

Hello,

The function is DecimalTostring(Decimal input, "supress_zero")

Before using this function covert your input to Decimal

Thanks

Ragasambath

If you use the "supress zero" option on the decimaltostring, it will remove zero's after the decimal also. So if the value was 32.000 it would come out as 32

Where is this documented?

The function is documented in "Parallel Job Developer Guide" however the different rtypes are not really present there. The different options are documented in "Orchestrate Operator Reference" doc.