CLI/ODBC configuration keywords listing by category - IBM DB2 9.7 for Linux, UNIX, and Windows

The CLI/ODBC configuration keywords are divided into the listed categories:

Compatibility configuration keywords
Data source configuration keywords
Data type configuration keywords
Enterprise configuration keywords
Environment configuration keywords
File DSN configuration keywords
Optimization configuration keywords
Service configuration keywords
Static SQL configuration keywords
Transaction configuration keywords

While most CLI/ODBC configuration keywords can be set in the db2cli.ini initialization file or by providing the keyword information in the connection string to SQLDriverConnect() function, the Trusted_Connection Keyword can be set only with SQLDriverConnect().

Compatibility configuration keywords

Use the compatibility configuration keywords to define DB2® behavior. You can set the compatibility configuration keywords to ensure that other applications are compatible with DB2.

Data source configuration keywords

General keywords associated with a data source configuration.

Data type configuration keywords

Use the data type configuration keywords to define how DB2 reports and handles various data types.

Enterprise configuration keywords

Use the enterprise configuration keywords to maximize the efficiency of connections to large databases.

Environment configuration keywords

Use the environment configuration keywords to define environment-specific settings, such as the location of various files on the server and client machines.

File DSN configuration keywords

Use the File DSN configuration keywords to set the TCP/IP settings for a file DSN connection.

Optimization configuration keywords

Use the optimization configuration keywords to speed up and reduce the amount of network flow between the IBM Data Server Driver for ODBC and CLI and the server.

Service configuration keywords

Use the service configuration keywords to help in troubleshooting problems with CLI/ODBC connections. Programmers can also use service configuration keywords to gain a better understanding of how their CLI programs are translated into calls to the server.

Static SQL configuration keywords

Use the static SQL configuration keywords when running static SQL statements in CLI/ODBC applications.

Transaction configuration keywords

Use the transaction configuration keywords to control and speed up SQL statements that are used in the application.