Hi all,
I have this requirement in my project wherein I am supposed to use the SIGN function in order to find if the augument (Number) is positive , negative or zero. Does anyone know what function I can use in Parallel jobs to attain the same funtionality.
Thanks,
Priya.
DataStage Equivalent of the SIGN Function in Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Thu Sep 11, 2008 11:47 pm
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. Try what Oracle does under the covers.
or, if you prefer, try this.
I'm surprised you could not work that out for yourself.
Code: Select all
If InLink.TheNumber = 0 Then 0 Else InLink.TheNumber / Abs(InLink.TheNumber)
Code: Select all
If InLink.TheNumber = 0 Then 0 Else If InLink.TheNumber > 0 Then 1 Else -1
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 22
- Joined: Thu Sep 11, 2008 11:47 pm
- Location: Bangalore