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
datastage PX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
datastage PX
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
round off
Floor is used to get the previous integer value
I want the value after deciaml to be rounded to 2 places
I want the value after deciaml to be rounded to 2 places
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
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)
Thanks and Regards!!
dspxlearn
dspxlearn