UseOldStpCall CLI/ODBC configuration keyword

db2cli.ini keyword syntax:

UseOldStpCall = 0 | 1

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.