decimal15,8 * decimal20,4

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

decimal15,8 * decimal20,4

Post by ds_is_fun »

I have a biz rule where I multiply col1 of type dec15,8 with dec20,4 and my target type is dec20,4. To avoid any possible DS warnings do I implicitly convert anything?
Ronetlds
Participant
Posts: 28
Joined: Thu Mar 30, 2006 12:48 pm

Post by Ronetlds »

Along with the mathematical type conversion functions, you may want to use the mathematical functions Floor, Ceil and Mod to get the level of precision you want by rounding or truncating.
Post Reply