Compatible Netezza and CLI/ODBC driver attributes

Certain IBM Netezza environment, connection and statement level attributes can be can be used in place of CLI/ODBC attributes when establishing a connection between a Netezza application and Db2® server.

Table 1. The following Netezza attributes can be used to specify connection settings. The corresponding CLI/ODBC attributes with similar functionality are listed as well.
Netezza attribute	CLI Connection string attributes
SQL_ATTR_CLIENT_USERID	SQL_ATTR_INFO_USERID
SQL_ATTR_CLIENT_WRKSTNNAME	SQL_ATTR_INFO_WRKSTNNAME
SQL_ATTR_CLIENT_APPLNAME	SQL_ATTR_INFO_APPLNAME
SQL_ATTR_CLIENT_ACCTSTR	SQL_ATTR_INFO_ACCTSTR
SQL_ATTR_CLIENT_PROGINFO	SQL_ATTR_INFO_PROGRAMNAME
SQL_ATTR_CONNECTION_TIMEOUT	SQL_ATTR_RECEIVE_TIMEOUT