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.


Rate this page:

(0 users)Average rating

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:

2013-02-19

Translate my page

Machine Translation

Content navigation