nvl equivalent in uvsh
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
nvl equivalent in uvsh
Is there any nvl equivalent function to use in select queries of uvsh. Basically want to replace all null with an empty string.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
EVAL "IF ISNULL(column) THEN '' ELSE column"
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.
I have a similar usage in select query involving convert as well. Something like thisray.wurlod wrote:Code: Select all
EVAL "IF ISNULL(column) THEN '' ELSE column"
Code: Select all
select EVAL "CONVERT(@TM:@VM,'.', Field1,Field2,Field3) from H_TABLE;
I applied the above null check condition.
Code: Select all
select EVAL "CONVERT(@TM:@VM,'.', If Isnull(Field1) then '' else Field1,If Isnull(Field2) then '' else Field2, If Isnull(Field3) then '' else Field3) from H_TABLE;
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: