Determines when stored procedure arguments are described.
- db2cli.ini keyword syntax:
- DescribeCall = 1 | -1
- Default setting:
- DB2® CLI does not request
stored procedure argument describe information when it prepares a
CALL statement.
- Equivalent connection attribute:
- SQL_ATTR_DESCRIBE_CALL
- Usage notes:
- By default, CLI does
not request input parameter describe information when it prepares
a CALL statement. If an application has correctly bound parameters
to a statement, then this describe information is unnecessary and
not requesting it improves performance.
The option values are:
- 1 = SQL_DESCRIBE_CALL_BEFORE. CLI always
requests describe information from the server, ignoring the binding
information provided by the application. Setting DescribeCall to 1
will also set DeferredPrepare to 0 which means that describe information
will also be requested for dynamic SQL statements. Note that setting
DeferredPrepare to 0 will not set DescribeCall to 1.
- -1 = SQL_DESCRIBE_CALL_DEFAULT (default). CLI does
not request describe information from the server and uses the binding
information provided by the application. If the CALL statement execution
fails, then the CLI error
recovery logic requests input parameter describe information from
the server and issues the CALL statement again.
DB2 Version 9.7 for Linux, UNIX, and Windows