DSXchange

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

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

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