1) MY job is having lookup
first lookup with conditon(isnotnull(x ) and isnotnull(y)) --continue and looup is reject
ref
|
|
ds---------lkp-------output
when I am replcing the above datastage job with DB2 Query
where fields
src ref
x (nullable yes) x (nullable yes)
x (nullable yes) y (nullable yes)
a (nullable no)
b (nullable no)
c (nullable yes)
Query
select
a,
b,
CASE WHEN LTrim(RTrim(x)) <> '' THEN x ELSE a END AS x ,
IPBLMSP.IICNL1 AS IICNL1,
CASE WHEN LTrim(RTrim(y)) <> '' THEN y ELSE b END AS y
from srource src
inner join on reference ref
(src.x=ref.x
and src.y=ref.y)
the above query is not working kindly guide me on the same
Problem with lookup condition continue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia