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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.