Page 1 of 1
how to join the two db2 sources
Posted: Thu Sep 15, 2005 2:32 am
by sravan
Hi guys,
iam new ti paralell jobs and db2
plz help me out on this.
how to join the two db2 sources in paralell jobs
again db2 as a target.
thanks in advance for any of the early responces.
bye
waitng for responce
Posted: Thu Sep 15, 2005 4:54 pm
by vmcburney
You have posted in the DataStage TX forum but you are referring to parallel jobs, which belongs in the DataStage Enterprise forum. You can join two DB2 tables in the source database stage via a user-defined SQL statement, you can join them in a job via the join, merge or lookup stages. Refer to the Parallel Job Developers Guide for details on any of these stages.
Posted: Fri Nov 04, 2005 2:05 am
by murali
You can join two DB2 tables in the source database stage via a user-defined SQL statement, you can join them in a job via the join, merge or lookup stages. Refer to the Parallel Job Developers Guide for details on any of these stages
Posted: Fri Nov 04, 2005 5:57 am
by ray.wurlod
You could also create a TX map that references the join within DB2. Provided, of course, that you have DataStage TX and the TX plug-in stage installed.
Posted: Wed Nov 30, 2005 4:36 pm
by olgc
In order to use user-defined SQL statement to join two db2 databases, you need the DB2 federation configuration.