Uses an alternative method to invoke a stored procedure.
ODBC
PBNewSPInvocation = 'value'
PBNewSPInvocation = 'No'
Output parameters might not be returned when you use an embedded SQL command to call a stored procedure. You can set PBNewSPInvocation to ‘Yes' to use an alternative method to invoke a stored procedure. The behavior of the DataWindow Designer ODBC driver when this parameter is set is consistent with the default behavior of the OLE DB driver.
If PBNewSPInvocation is set to ‘Yes', the alternative method is used when you retrieve data into a DataWindow object that uses a stored procedure. This parameter has no effect when you use RPC to invoke a stored procedure.
When PBNewSPInvocation is set to ‘Yes', the values of the PBUseProcOwner and CallEscape parameters are ignored.
To set the parameter for all connections, add the
following line to every relevant section (such as ;IBM
DB2/NT 2.1 DB2CLI for a DB2 connection on
Windows) in your pbodb105.ini file:
PBNewSPInvocation='Yes'
For more information about editing pbodb105.ini, see the Appendix in Connecting to Your Database.
You can also set the parameter at runtime. For example:
SQLCA.DbParameter="PBNewSPInvocation='Yes'"
The value that is set at runtime overrides the value in the pbodb105.ini file.
To obtain the value of the stored procedure’s output parameter, use the OUTPUT or OUT keyword. For example:
DECLARE sp_test PROCEDURE FOR SP1 VAR0=:ARGIN, VAR1=:ARGOUT OUTPUT USING SQLCA;
If the stored procedure contains result sets, you must fetch
the result sets first. If the stored procedure has a return value
and you want to obtain it, use the format RC=SP1:
DECLARE sp_test PROCEDURE FOR RC=SP1 VAR0=:ARGIN, VAR1=:ARGOUT OUTPUT USING SQLCA;
