Issue with webservices pack

aladap12 · Post by **aladap12** » Thu Jan 03, 2008 9:12 am

Hi all

Once again with my problem

Here we are you using datastage 7x server jobs with webservices pack

we are using webservices client as source and connecting to website(we pick up source data from website) and transfrom that data and loading into our staging table. This my first sequecer job , in the we have 7 different service operation that are loading into 7 tables.

our job design skelton is like

webservices client---->xml input--->flatfile---->transformer----->oracletab

And form there our second sequencer starts. this will reformat the data and sending data to MQ series.. Consits set of 7 jobs based on our business requirements

Mainly both the sequencer jobs are schedule every morning with a time gap of 15 mins.. and source side they had a automated programme that
runs everyday to upload data into webservices.

Secondly my problem is .Some time there is a problem in loading the data into webservice (at source side ) and their programme stops in the middle of loading. so we are getting in cosnsitent data with our first sequenser job.

is there any solution in datastage where my job waits till the completion of the loading and make sure that data is loaded properly and then start
sequnecer job to pick up the data

Hope u understan my problem.

Thanks in advance

chulett · Post by **chulett** » Thu Jan 03, 2008 9:24 am

I would think the short answer is 'no' and that that burden lies squarely on the shoulders of the web service.

eostic · Post by **eostic** » Thu Jan 03, 2008 10:57 am

Right.... the Web Service ought to send back something telling you that all is not ready......

...or better yet, have the remote location (where the Web Service and the data are) be the controller..... let "them" start the DataStage process/sequence when everything is ready..... dsjob will work, or else consider using RTI and making your job into a Service, if the other location is SOA savvy.

Ernie