DescribeCall CLI/ODBC and IBM data server driverconfiguration keyword
Determines when stored procedure arguments are described.
- db2cli.ini keyword syntax:
- DescribeCall = 1 | -1
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="DescribeCall" value="1 | -1"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- 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.