DSXchange

Thank you. I have resolved my problem. Since Money should always be represented by decimal, I changed it to DECIMAL (20,2), then used a combination of this function in the Transformer stage to display them as strings.
Trim(TrimF(DecimalToString(inputLink)),"0","L");

Thanks, I appreciate the response but I am still not getting the desired result. Did I misinterpret? Steps taken: 1. Input to the transformer stage: TOTAL_REV, Double 2. Stage variable Derivations and Stage Variables: Keep_These_Rows, TOTAL_REV, DXEchange1 trim(DXEchange1, "0","L"...

Migrating from DataManager to DataStage. I have a single sequence calling 18 job activities (parallel jobs) that must proceed if OK, and Fail if not OK. Must I really add a Terminator activity and trigger for all 18? Seems so clunky. Any best practice I can follow? Thanks

I am trying to convert a column that is DOUBLE input containing dollars and cents to a text file with no leading zeros and trailing zeros out to 2 decimals places. I am attempting this via a Transformer Stage, Stage Variable, but it is not working. Tried multiple ways, more and more creative, yet no...