Specifying the Catalog/Package field in a JDBC Call Procedure when calling a DB2 stored procedure.
book
Article ID: KB0089269
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks
-
Not Applicable
-
Description
Resolution: Description: ============ I am able to select a value for the Catalog/Package field. But at run time the following error is reported:
BW-JDBC-100014 Job-1000 Error in [Process Definition.process/JDBC Call Procedure] "JDBC error reported: (SQLState = HY000) - java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver][DB2]The Specified library "<schema>.<Catalog/package>.<procedure>" could not be loaded." caused by: java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver][DB2]The Specified library "<schema>.<Catalog/package>.<procedure>" could not be loaded.
Environment =========== All platforms All BW versions [SME-Comments] My recommendation for the Scope for the KB Article : Customer
Resolution: ========== A DB2 stored procedure is qualified by <schema name>.<procedure name>. That is, the fully qualified procedure name does not have a catalog or package name. To resolve the error, you need to set the Catalog/Package field to blank.
Issue/Introduction
Specifying the Catalog/Package field in a JDBC Call Procedure when calling a DB2 stored procedure.