Specifies how a CALL statement will be resolved.
Syntax:
CALL_RESOLUTION={IMMEDIATE | DEFERRED}
IMMEDIATE
Parameters:
| 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. |
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).