UseOldStpCall CLI/ODBC and IBM data server driver configuration keyword
Controls how cataloged procedures are invoked.
- db2cli.ini keyword syntax:
- UseOldStpCall = 0 | 1
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="UseOldStpCall" value="0 | 1"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- Invokes procedures with the CALL method, where EXECUTE privilege must be granted on the procedure.
- Usage notes:
The user ID that calls the stored procedure must have EXECUTE privilege on the procedure. Only the creator of the procedure requires EXECUTE privilege on any required packages.
The UseOldStpCall keyword controls which method is used to invoke the procedure. Setting the UseOldStpCall keyword value to 1 causes the procedure to be called with the deprecated sqleproc() API when the precompiler fails to resolve a procedure on a CALL statement. Setting the UseOldStpCall keyword value to 0 requires EXECUTE privilege on the procedure.