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
join stage where condition
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.