DB2 Version 10.1 for Linux, UNIX, and Windows

Call to a stored procedure with a three-part name

C and C++ embedded SQL applications can call a stored procedure with a three-part name when the connected database server supports use of three-part names.

A three-part name consists of schema_name.module_name.procedure_name, or schema_name.package_name.procedure_name. The DB2® for Linux, UNIX, and Windows Version 9.7 and later server supports use of three-part names, containing a package name, only if the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA.

EXEC SQL CALL schema_name.module_name.procedure_name(:parm);
EXEC SQL CALL schema_name.package_name.procedure_name(:parm);