Solved

if else

Posted on 2006-11-23
2
893 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
Comment Utility
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 50 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now