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
Call to Web Service - Question about Output Rows
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
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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