UseOldStpCall CLI/ODBC configuration keyword

db2cli.ini keyword syntax:

UseOldStpCall = 0 | 1

Default setting:

Invokes procedures using the new CALL method where GRANT EXECUTE must be granted on the procedure.

Usage notes:

 

Prior to DB2 Universal Database™ Version 8, the invoker of a procedure had to have EXECUTE privilege on any package invoked from the procedure. Now, the invoker must have EXECUTE privilege on the procedure and only the definer of the procedure has to have EXECUTE privilege on any required packages.

This keyword controls which method is used to invoke the procedure. Setting UseOldStpCall on causes the procedure to be invoked using the deprecated sqleproc() API when the precompiler fails to resolve a procedure on a CALL statement. Turning this keyword off will invoke procedures where GRANT EXECUTE must be granted on the procedure.