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.
Converting SQL query into Datastage server job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Mon May 07, 2007 4:26 am
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Converting SQL query into Datastage server job
HI Suresh,sureshchandra wrote: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.
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
SMB
-
- Participant
- Posts: 92
- Joined: Mon May 07, 2007 4:26 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: