datastage PX

[karrisuresh]

HI I have a column say Employee_age,
I need to round it 2 decimal places
could any pls let me know the exact syntax
I can give a hint for better understanding

NVL(round(sum(Employee_age),2),0.00)

I can do all except the round function in the above one

thanks in advance

[ray.wurlod]

Try floor() for rounding down. Explore all the Transformer stage functions in Appendix A of Parallel Job Developer's Guide manual.

[karrisuresh]

Floor is used to get the previous integer value
I want the value after deciaml to be rounded to 2 places

[gateleys]

Code: Select all

Fix(YourValue,2)

[dspxlearn]

While pulling your field, set the target decimal place to 2. Datastage by default rounds a value if the target decimal length is less than the source.

Code: Select all

Decimal(20,6) --> while pasing to the target set the length to Decimal(20,2)