Page 1 of 1

join stage where condition

Posted: Tue Aug 03, 2010 12:38 am
by developeretl
Hi,
Iam using the db2 stages and i want to implement where logic in the join stage .... is it possible for me to specify where conditions in the join stage??? please guide me

Posted: Tue Aug 03, 2010 1:13 am
by nani0907
Where condition is not possible in Join stage.

Posted: Tue Aug 03, 2010 3:05 am
by ray.wurlod
Only implicitly. Within the Join stage you identify the "join keys" which would, in SQL, occur on either side of an "=" condition in a WHERE clause. But no other conditions are possible - it's a "pure" join.