Join 2 tables on a key without using lookup
Moderators: chulett, rschirm, roy
Join 2 tables on a key without using lookup
hello,
I am using server edition 7.5.1
I am want to join two diff tables from DB2 WITHOUT using lookup stage(hashed file)
reply soon
I am using server edition 7.5.1
I am want to join two diff tables from DB2 WITHOUT using lookup stage(hashed file)
reply soon
You can do a lookup directly to a DB2 table from a transform stage in DataStage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Doesn't need to be user-defined. You can generate a query containing join criteria. Simply put a comma-separated list of table names into the Table Name field, and the join criteria into the WHERE field on the Selection tab. In the Columns grid make sure that no ambiguities exist by using fully-qualified column names in the Derivation field.
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.
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
Re: Join 2 tables on a key without using lookup
There you go. You've got a whole bunch of suggestions. But Rishabh, any reason why you would NOT want to use the hashed file for reference? Just curious.
gateleys
gateleys
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Isn't the (+) syntax only for Oracle? It's not part of the SQL CAE Access Group's standard.chulett wrote:Or you can use the 'old' style outer syntax - (+) - in the generated sql which will get you everything but a full outer 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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: