DSXchange

Thanks Ernie ! I was able to implement this scenario using xml input and xml output stage. Your blog was helpful in doing the same. I also referred http://www.ibm.com/developerworks/webservices/library/ws-complexws/index.html .Wanted to know if its possible to implement , same same scenario using XM...

Could you please let me know to how to aggregate multiple input rows for binding it to a single row using new 'xml' stage ?

thanks eostic

Thanks Mike

Kindly suggest a way pass bulk records in a single webservice call in datastage. The webservice operations that i am dealing with ,can accept multiple records in a single webservice call. Kindly advice me the best way to do this scenario.

You can use funnel stage if all the input files records have to be stacked up in a csv file.(if metadata are same) If its a column wise addition you can use join stage or merge stage or look up stage

In business scenario i have a requirement to write records to file created during run-time. .(number of files to be created and name of the files to be created is unknown) Its based on the input records.(for each group of records has to loaded to a file with that particular group name).I have implem...

Kindly suggest best way to capture the error message,when a job fails and sent the error message in notification. Which is the best dsjob command to do the same ?

Thanks Chulett.

In my business requirement ,i have a requirement to make update on the source table simultaneous while its inserting record to the target table.For implementing this i have used a single oracle connector with multiple input link to the connector ,so that both transaction happens simultaneously. Afte...

Thanks Ray.

datastage version 8.7

In one of my business scenario , i have to do transaction of data to two tables simultaneous.(one is update and other is insert) transaction of records to both tables have to happen simultaneously, since even during the fail over of the job, for all the inserted records to one table, update-ion of o...

Thanks Craig and Ernie.

Thanks Ernie for reply. In my scenario i have sent those records to a live running App.Will there be any other option which let us to call webservice by creating request file for batch records ,instead of calling one by one using webservice stage ?