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
Parent topic: DB2 Compiler Directive Options
Related reference
QUALIFIER