In the transformer, I set SV = D1 * D2. I then convert SV to a string using DecimalToString( SV, "fix_zero,suppress_zero" ) and print the result to a file.
The problem is that I am seeing more than 2 decimal places in the output. For example,
Code: Select all
D1 = 0.71449
D2 = 258307.5
0.71449 * 258307.5 = 184558.125675
Does this occur because DecimalToString() is displaying an underlying value which is actually stored with more than two decimal places? Or am I confused about the meaning of "precision" and "scale" in DataStage decimal variable declarations?
TIA