how to join the two db2 sources

sravan · Post by **sravan** » Thu Sep 15, 2005 2:32 am

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

vmcburney · Post by **vmcburney** » Thu Sep 15, 2005 4:54 pm

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.

murali · Post by **murali** » Fri Nov 04, 2005 2:05 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Nov 04, 2005 5:57 am

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.

olgc · Post by **olgc** » Wed Nov 30, 2005 4:36 pm

In order to use user-defined SQL statement to join two db2 databases, you need the DB2 federation configuration.