IBM Support

Is it necessary to check all the input parameters/fields for a Database Call Procedure activity in Cast Iron Studio?

Technote (FAQ)


Question

Is Cast Iron Studio required to pass all parameters in a Database Call Procedure?

Answer

No, Cast Iron Studio is not required to pass all parameters in a Database Call Procedure. The interface allows the selection of all parameters or some of the parameters as seen in the following screen shots:


This as well with omissions:



Omissions between selections are not allowed, as seen in the following screen shot, and will generate an error in runtime or a logical error where the stored procedure will return an unexpected result.



As shown above, the WORKSPACE parameter is omitted. Since it is a parameter that is between two selected parameters on the list (STAGING_TABLE AND WHERE_CLAUSE), this will result in either a logical error or functional error.


Document information

More support for: WebSphere Cast Iron Cloud integration
Studio

Software version: 6.1.0.3

Operating system(s): Windows

Software edition: Cloud, Physical, Virtual

Reference #: 1588527

Modified date: 19 February 2013