Variable Body

[U]

I'm on a new project in which the goal is to replace Excel macros with DataStage jobs. The VBA does some checking for mandatory fields, and conversions to upper case, and then invokes web services that update a DB2z database through a CICS transaction layer.

There is an absolute requirement that DataStage invoke those web services. Direct access to CICS or to the database is prohibited.

Another business rule, however, is that if a non-mandatory field in Excel is empty, it is not to be included in the payload. Does the Web Service Transformer stage allow for columns to be conditionally included, where the condition is that the column is non-empty?

If not, which I suspect to be the case, I fear that the only alternative would be to build at least the SOAP body upstream in a Transformer stage. Does that seem to be it, or is there some clever trick that we could employ?

We have WSDL files for all of the web services.

Thank you for your time.