CALL_RESOLUTION={IMMEDIATE | DEFERRED}
IMMEDIATE
| IMMEDIATE | Specifies that the CALL statement will be excecuted as a normal SQL statement. If the name being called cannot be resolved, the precompiler reports error SQL0204. |
| DEFERRED | Specifies that the CALL statement will be executed as an invocation of the deprecated sqleproc() API. |
| Default: | IMMEDIATE |
Comments:
You must be using DB2 LUW V8.1 or later for this directive to work.
You need to set CALL_RESOLUTION=DEFERRED if you place the name of the stored procedure in a host variable or if the precompiler fails to resolve the procedure on a CALL statement (in which case, the precompiler reports error SQL0204).