SQLDriverConnect() API with IBM Netezza clients

Certain IBM Netezza ODBC.odbc.ini file entries can be used to establish connection settings with a Db2® server using the SQLDriverConnect() API, as if they were Db2 CLI/ODBC Driver connection string keywords.

The following Netezza keywords and their values will be recognized by SQLDriverConnect() API. They can be used in place of the corresponding CLI keywords with similar functionality.

Table 1. The following table lists several common Netezza .odbc.ini file entries used to specify connection settings, and the compatible CLI/ODBC connection string keyword. These are used with SQLDriverConnect () .
Netezza .odbc.ini entry	CLI Connection string keywords
Servername	Hostname
SchemaName	CurrentSchema
Username	UID
Password	PWD
ReadOnly	ReadOnlyConnection
LoadRoundFraction	DecimalFloatRoundingMode
DateFormat	DateTimeStringFormat
ClientWorkStnName	ClientWrkStnName
ClientAcctString	ClientAcctStr
ClientProgramInfo	ProgramName
LoginTimeout	ConnectTimeout
securityLevel	Security
CaCertFile	SSLServerCertificate
PreFetch	BlockForNRows
Socket	FET_BUF_SIZE

Note: If you want to establish an SSL connection between the Netezza client application and the Db2 database server, then you must set the SecurityLevel keyword to PreferredSecured or OnlySecured when establishing a connection.