IBM WebSphere Cast Iron Studio (hereafter called Studio) is used to develop orchestrations that call database stored procedures. Stored procedures commonly return a result set containing the results of an SQL select statement without specifying the names and types of the individual fields. In these cases, the IBM WebSphere Cast Iron Cloud Integration (hereafter called Cast Iron) developer must create an XML schema to tell Studio the structure of the results. This tutorial explains how to create the XML schema and contains a step-by-step example.
This tutorial is intended for application developers. It contains detailed steps for every stage of the sample application development, so even beginners can complete it. However, prior knowledge of the Extensible Markup Language (XML), XML Schema, and Extensible Stylesheet Language Transformations (XSLT) standards will increase your understanding of the material.
This tutorial uses the following software:
- IBM WebSphere Cast Iron Studio V22.214.171.124 or later
- IBM DB2® V9.7 or later
- Microsoft™ Windows™ V7 or later
This tutorial takes approximately 1 to 2 hours to complete.