QUALIFY-CALL

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

Properties:

Default: 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