8 NETEZZA

============================================================================= Simba Netezza ODBC Driver with SQL Connector Release Notes =============================================================================

The release notes provide details of enhancements, features, and known issues in Simba Netezza ODBC Driver 1.0.5, as well as the version history.

1.0.5 =======================================================================

Released 2018-07-27

Enhancements & New Features

• [NZO-608] Upgrade to OpenSSL 1.1.0h

  The driver now uses OpenSSL 1.1.0h for encryption of data.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application.

• Translations of functions nested within the same {fn } block are not supported.

  The driver does not support functions that are nested within the same {fn } block. For example, the following is not supported by the driver, because convert and substring are nested within the same {fn } block:

  SELECT tm_col2 FROM DBF.TIME_ WHERE {fn SECOND(tm_col2)}={fn convert(substring(tm_col2||’’,7,2), SQL_INTEGER)}

  As a workaround, specify an additional function block. For example, the following is supported by the driver, because substring is now within its own {fn } block:

  SELECT tm_col2 FROM DBF.TIME_ WHERE {fn SECOND(tm_col2)}={fn convert({fn substring(tm_col2||’’, 7,2)},SQL_INTEGER)}

Version History ==============================================================

1.0.4 ————————————————————————

Released 2017-12-15

Resolved Issues The following issues were resolved in Simba Netezza ODBC Driver 1.0.4.

• In some cases, memory leaks may occur during certain data conversions.

1.0.3 ————————————————————————

Released 2017-10-30

Resolved Issues The following issues were resolved in Simba Netezza ODBC Driver 1.0.3.

• When the Use Windows Trust Store option (the UseTrustStore property) is enabled, but the trust store does not contain an SSL certificate, the driver returns a communication link error (1001) instead of the expected cert file missing error (1003).

1.0.2 ————————————————————————

Released 2017-04-28

Enhancements & New Features

• Use Windows Trust Store to verify connection

  The driver can now verify the connection to the data store with an SSL certificate stored in the Windows Trust Store. To use the Windows Trust Store, select the Use Windows Trust Store check box, or set the UseTrustStore option to 1.

• Improved driver performance during prefetch

  In certain cases involving prefetching data, driver performance has been improved up to 300%.

• Driver-specific error message locale settings

  You can now specify the locale for the driver error messages by using the Locale or DriverLocale configuration options.

Resolved Issues The following issues were resolved in Simba Netezza ODBC Driver 1.0.2.

• Some fields are missing data for returned records.

• Params attribute incorrectly spelled as Param in NZMessages.xml file.

1.0.1 ————————————————————————

Released 2017-02-17

Enhancements & New Features

• Improved driver performance

  Support for new parameters and workflows increase the driver’s performance for various tasks. This includes implementation of SQLBindParameter() for bulk insertion.

Resolved Issues The following issues were resolved in Simba Netezza ODBC Driver 1.0.1.

• SQL_DATA_AT_EXEC is not implemented.

  This function is now implemented.

• ETW logging is not implemented.

  This function is now implemented.

• When running a console application, pressing “CTRL+C” could cause the application to terminate unexpectedly.

• Driver name is hard coded as “NetezzaODBC”, this should be the binary file name.

• For variable size data, if the buffer size is less than the length of the data string the driver would display a system message saying “Partial data retrieval supported yet”.

• If the data store name contains the underscore ( _ ) character, the application would terminate unexpectedly with the system message “ERROR: invalid identifier”[datasourcename]" contains an invalid character ()".

1.0.0 ————————————————————————

Released 2016-12-20

• Version 1.0.0 is the initial release of Simba Netezza ODBC Driver.

==============================================================================