Converting SQL query into Datastage server job

[sureshchandra]

Hi all,
I'm converting DB2 query in Ds jobs.
I', having four tables in my query.In that one table is date and the rest are say for eg: A,B and C.
for the first table i done a seprate job
DB2------->Trans------>Flatfile
job is successful i got the dates.
Now i have to insert the target(flat file) into the second job
so that my final out put should be with A,B,C and dates(flatfile).
I taken the stages as
ODBC--------->Trans------------>Hashfile.
Can u pls help me in how to connect this flat file and extract the date.
Thanks in advance.

[baglasumit21]

Hi all,
I'm converting DB2 query in Ds jobs.
I', having four tables in my query.In that one table is date and the rest are say for eg: A,B and C.
for the first table i done a seprate job
DB2------->Trans------>Flatfile
job is successful i got the dates.
Now i have to insert the target(flat file) into the second job
so that my final out put should be with A,B,C and dates(flatfile).
I taken the stages as
ODBC--------->Trans------------>Hashfile.
Can u pls help me in how to connect this flat file and extract the date.
Thanks in advance.

HI Suresh,
Can you please elaborate your problem. What are the source table fields and formats and in what format do you want output. May be you can use a query to achieve it or also user lookups in datastage to achieve it. Please provide more details

[sureshchandra]

Hi,
My source is a DB2 query.In the source query i'm having four tables
in my query.Ihave to convert this into ds server jobs.
Pls give the clew how to do?



Thanks in advance

[ray.wurlod]

Analyze the logic of the SQL and write out a processing specification; a target-from-source mapping. Then code that using a DataStage job.

Why an ODBC stage?