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.
Variable Body
Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.
Return to “IBM<sup>®</sup> SOA Editions (Formerly RTI Services)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration