EnableNamedParameterSupport CLI/ODBC and IBM data server driver configuration keyword
Specifies whether named parameter processing is enabled.
- db2cli.ini keyword syntax:
- EnableNamedParameterSupport = TRUE | FALSE
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="EnableNamedParameterSupport" value="TRUE | FALSE"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- Named parameter support is off (FALSE).
- Equivalent environment or connection attribute:
- None
- Usage notes:
- Named parameter processing allows applications to use named parameters (for example,
:name) in addition to traditional unnamed parameter markers that are represented by a question mark (?). The following options are available to enable or disable named parameter support:- TRUE - Named parameter processing is enabled. For Db2® version 9.7 and later, CLI sends the statement text as it is to the server for processing. For all other servers, CLI substitutes the statement text by replacing named parameters with question marks (?) before sending the statement to the server for processing.
- FALSE - Named parameter processing is off, and CLI does not process the parameter markers.
There is no support for the ability to bind by name. CLI processes anything that matches a valid parameter marker, and treats it as if it is a normal parameter marker represented by a question mark (?).