DSXchange

Hi
Thats just a sample target.The target is a DB2 table

Hi, My sample input is as following CUST_ID YEAR MONTH QTY 1 2008 JAN 1000 1 2008 FEB 1200 1 2008 MAR 1300 2 2007 JAN 1000 2 2007 FEB 1900 And my required target is CUST_ID JAN_08 FEB_08 MAR_08 JAN_07 FEB_07 1 1000 1200 1300 0 0 2 0 0 0 1000 1900 Here my target is not static. For example at the end ...

Hi All I have created 10 xml files using an XML output stage. I can save this to my system. But i want put those files into a message queue using a Datastage job. Can i use MQ connector stage after XML out put stage to collect those XMLs created from XML output stage My data flow like this Sequentia...

Hi Craig
It will be great if yuo can explain the design details little more..


Thanks

Hi All I have some 100 records in my DB2 table. My requirement is to convert those records into separate XML files in such a way that each XML will have the details of one and only one record. Here in this case i want 100 XML file as out put. How can i desgin a Datastage job for this requirement. Pl...

Can somebody help me to create a routine for the above purposes i.e to check the current time against the end the and acoordingly exit the loop when required...
Thanks

Hi
So then how i will be able to run a loop job from a particular start time to end time. Please give me a solution

Hi The value for the variables in the UserVariable_Activity stage given as follows Starttime----->Iconv("11:42AM","MTS") Endtime------>Iconv("11:45AM","MTS") Counter------>1 These variables were called in the Startloop_Activity satge as follows From------>Star...

Hi

It will be great if anybody can give me an alternate design for the above job

Thanks

Hi All I am working with a job which should run in a loop for a particular time frame. Its running in loop. But when the end time exceeds the given time limit, the job gets aborted. Actually i want the job in finished ok state. The warning before the fatal error which i got is "JOB_JS..JobContr...

Hi
This is an extension to my earlier doubt.If each time when we run the job, it takes different time to complete how we can give the counter definition in start loop
Thanks

Hi Actuall I have used the start loop stage and end loop stage. But its doesnot provide the option to run a job in loop within a particular time frame. If the job take different time to run the job in loop execution, the strategy of implementing the job using the following stages(in order) "Use...