Works with the DB2 QUALIFIER directive to modify EXEC SQL CALL statements by attaching the schema name to the stored procedure name.
Syntax:
QUALIFY-CALL
NOQUALIFY-CALL
Dependencies:
Must be used with QUALIFIER DB2 compiler directive option.
Example:
When QUALIFY-CALL is used with QUALIFIER:
DB2(QUALIFIER=TESTER QUALIFY-CALL)
This statement:
exec sql call mystoredproc(:parm1) end-exec
Becomes:
exec sql call TESTER.mystoredproc (:parm1) end-exec