Is it necessary to check all the input parameters/fields for a Database Call Procedure activity in Cast Iron Studio?
Is Cast Iron Studio required to pass all parameters in a Database Call Procedure?
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.
More support for:
WebSphere Cast Iron Cloud integration
Software version: 126.96.36.199
Operating system(s): Windows
Software edition: Cloud, Physical, Virtual
Reference #: 1588527
Modified date: 19 February 2013