?
Solved

if else

Posted on 2006-11-23
2
Medium Priority
?
905 Views
Last Modified: 2008-01-09
hi there
as
T1.HLOC = IF T2.HLOC  IS MISSING THEN '.' ELSE T2.HLOC   dont work in db2
whts the other way around
thanks
bobby
SELECT  
 T1.HLOC  ,
 T2.HLOC
FROM
   (STG_PURCHDE1_WR T1  LEFT OUTER JOIN V_RRR_PURCHDE2_WR T2
       ON
  T1.HCOMP  = T2.HCOMP
 AND T1.HDIV  = T2.HDIV
AND T1.DPORD#  = T2.DPORD#
AND T1.DLINE#  = T2.DLINE#
AND T1.HLOC = IF T2.HLOC  IS MISSING THEN '.' ELSE T2.HLOC  )
0
Comment
Question by:bobby2929
2 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 18006773
hi
what you need is the case expression  :
 T1.HLOC = IF T2.HLOC  IS MISSING THEN '.' ELSE T2.HLOC

will be

T1.HLOC = CASE WHEN T2.HLOC IS NULL THEN '.'
                         WHEN SOME-OTHER-CONDITION THEN SOME-OTHER-VALUE
                          ELSE T2.HLOC END

you have to write the END in order to close the case clause

momi
0
 
LVL 7

Accepted Solution

by:
sachinwadhwa earned 200 total points
ID: 18007368
or use COALESCE function

T1.HLOC = COALESCE(T2.HLOC , '.')

COALESCE(T2.HLOC , '.') will return T2.HLOC,  if T2.HLOC is not null otherwise '.'

more help here:

http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/admin/r0000780.htm
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
Suggested Courses

592 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question