Specifies whether named parameter processing is enabled.
- db2cli.ini keyword syntax:
- EnableNamedParameterSupport = TRUE | FALSE
- 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®for Linux, UNIX, and WindowsVersion
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 (?).