DSXchange

Hi ray,
i'm sorry.Yes it is giving data source is empty.But while i'm running that query in QTODBC it is running fine.I'm getting the output.
Can u suggest me of what are the changes shoulkd i do.

Hi all,
I'm my source stage(ODBC).In view data i'm getting data source is empty.In my source stage i'm using tab user defined SQL query.
Pls help me how to resolve.





Thanks in advance

Hi Ray,
Pls be clear of how to do in aggreator stage.
should i add the STRT_DT and END_DT in source and do aggregation ?


I'm very thankful to u

Hi all, In source i'm having only one column. This is my query pls check it WITH DATES AS( SELECT MIN(XX_MA_DT) STRT_DT,MAX(XX_MA_DT) END_DT FROM (SELECT DISTINCT XX_MA_DT FROM EMP.T1 WHERE T1.XX_MX_DT < CURRENT DATE ORDER BY XX_MA_DT DESC FETCH FIRST 13 ROWS ONLY) TMP). I'm having only XX_MA_DT thi...

Hi all, In source i'm having only one column. This is my query pls check it WITH DATES AS( SELECT MIN(XX_MA_DT) STRT_DT,MAX(XX_MA_DT) END_DT FROM (SELECT DISTINCT XX_MA_DT FROM EMP.T1 WHERE T1.XX_MX_DT < CURRENT DATE ORDER BY XX_MA_DT DESC FETCH FIRST 13 ROWS ONLY) TMP). I'm having only XX_MA_DT thi...

Hi all,
My job design is
ODBC------>Trans---------->SeqFile.
I'm getting the dates as output.I won't recquired all the dates as out put.Among all i need only Max and Min dates.

Pls help me how to do this?


Thanks in advance

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

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) int...

Hi all,
Thanks for ur help.Issue is resolved.

Hi Ray,
thanks for ur response.
i have to do sum in Transformer.For eg:A+B=C.
Here A and B are columns which are there and C is the new column(sum(A+B)).So C is the new column i have to insert .


thanks in advance

Hi,
Can we do aggregation(sum) in transformer stage.If yes pls help me how to do?


thanks in advance

Hi Chulett,
Pls be clear.Any option is there to do distinct.Or i have to change the query to distinct.



Thanks in advance

Hi ArndW, I'm getting the out put like this eg:29-3-2008 29-3-2008 29-3-2008 29-3-2008 30-3-2008 30-3-2008 30-3-2008 30-3-2008 30-3-2008 30-3-2008 31-3-2008 31-3-2008 31-3-2008 31-3-2008 I have to distinct into 29-3-2008 30-3-2008 31-3-2008 Pls help me how to do.I'm using ODBC------>Trans-------->Fl...

Hi Andrew,
Thanks for ur response.
Can u help me how can i do it in transformer.
In stage variable what should i select?