DataStage Equivalent of the SIGN Function in Oracle

[Shaanpriya]

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.

[ray.wurlod]

Welcome aboard. Try what Oracle does under the covers.

Code: Select all

If InLink.TheNumber = 0 Then 0 Else InLink.TheNumber / Abs(InLink.TheNumber)

or, if you prefer, try this.

Code: Select all

If InLink.TheNumber = 0 Then 0 Else If InLink.TheNumber > 0 Then 1 Else -1

I'm surprised you could not work that out for yourself.

[Shaanpriya]

Wow... Thanks Ray for taking the time to reply for the query..