DB2 Version 9.7 for Linux, UNIX, and Windows

DB2NETNamedParam CLI/ODBC configuration keyword

Specifies if named parameters are used by DB2® .NET applications.

db2cli.ini keyword syntax:

DB2NETNamedParam = 0 | 1

Default setting:

The DB2 .NET Data Provider recognizes named parameters as parameters, but ignores positioned parameters, in SQL statements.

Usage notes:

By default, the DB2 .NET Data Provider processes tokens in an SQL statement with the format "@<paramname>" as named parameters and ignores any positioned parameters, where positioned parameters are specified with a '?' character or a colon followed by a name (:name).

The following is an example of a query that contains a named parameter:

SELECT * FROM T1 WHERE C1 = @param1

This is an example of a query that contains a positioned parameter:

SELECT * FROM T1 WHERE C1 = ?

Specify 0 to indicate that only positioned parameters will be recognized as parameters in SQL statements. This setting can improve application performance by reducing the overhead required to process named parameters.