Call to Web Service - Question about Output Rows

Nicole · Post by **Nicole** » Fri Oct 03, 2008 7:52 am

Hi! I am making a call to a web service from DataStage and in the web service (java) I want to populate the returning object and then it will return that object to DataStage and output that row of data to a results file.

Sometimes the object doesn't get populated and that is fine, but I don't want it to insert a new row into the output file, but it seems that every row is being output. Does anyone have any suggestions on how not to insert a row into the results file if the object doesn't have any data. Should I direct the empty rows to a different file? Any suggestions would be appreciated!

Thanks,

Nicole

eostic · Post by **eostic** » Fri Oct 03, 2008 7:33 pm

what is actually returned from the Service? blanks? nulls? Are you going directly from the WSTransformer into an rdbms stage? Could you implement a Transformer and use a constraint to prevent the rows from going thru if they don't have the right value (or are blank/null)?

Ernie

Nicole · Post by **Nicole** » Mon Oct 06, 2008 7:19 am

Yes, i'll try that, that probably will work, now that I think of it! Thanks!

eostic wrote:what is actually returned from the Service? blanks? nulls? Are you going directly from the WSTransformer into an rdbms stage? Could you implement a Transformer and use a constraint to prevent the rows from going thru if they don't have the right value (or are blank/null)?

Ernie