Hi,
Is there any functions available like NVL(input,'x'). ie., to return first non null value. Similar to NullToValue() in PX. Or If..Then...Else is the only case?
NVL in Server jobs?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You'll find these as Transforms, rather than as Routines. Create your own NullToValue transform in the same category. Of course, it will need two arguments, not one.
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.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Expanding on Ray's answer. Create a new transform 'NullToValue' with two input arguments, Arg1 and Arg2, where Arg1 is your input and Arg2 is the value if input is NULL. Put this code in the "Definition" field.
Whale.[/i]
Code: Select all
(IF ISNULL(%Arg1%) THEN %Arg2% ELSE %Arg1%)
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE