8 NETEZZA

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

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

For information about upcoming support deprecations or removals, see the Workflow Changes section. Deprecated features will not receive any updates, but will continue to be usable in their current state until support is removed in a future release.

1.0.12 =======================================================================

Released 2020-12-31

Enhancements & New Features

  • [NZO-729] Updated OpenSSL version

The driver now uses OpenSSL version 1.1.1g. Previously, the driver used OpenSSL version 1.1.1d.

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

  • The driver takes longer than expected to process bulk inserts that use an array of parameters.

  • 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)}

Workflow Changes =============================================================

The following changes may disrupt established workflows for the driver.

In addition to changes that are already implemented in the current version of the driver, this section describes potentially disruptive changes that will be implemented in a future version of the driver, so that you can plan accordingly.

Upcoming ---------------------------------------------------------------------

  • [NZO-700] Removing support for earlier versions of Linux

As early as January 2021, the driver will no longer support the following operating systems: - CentOS 6 - Red Hat Enterprise Linux (RHEL) 6
- Debian 8

For information about supported operating systems, see the Installation and Configuration Guide.

1.0.11 ---------------------------------------------------------------------

  • [SF-798][SF-796] Removing support for earlier versions of Windows

Beginning with this release, the driver no longer supports the following operating systems: - Windows 7 - Windows Server 2008 - Windows Server 2008r2 - SLES 11

In addition, the driver no longer supports Visual Studio 2013.

For a list of supported operating systems, see the Installation and Configuration Guide.

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

1.0.11 -----------------------------------------------------------------------

Released 2020-10-08

Enhancements & New Features

  • [NZO-650] Reporting the maximum length of database fields

You can now specify the maximum character length that the driver reports for the names of catalogs, columns, schemas, and tables. To do this, set the following new advanced options: - Max Catalog Name Length (the MaxCatalogNameLen property) - Max Column Name Length (the MaxColumnNameLen property) - Max Schema Name Length (the MaxSchemaNameLen property) - Max Table Name Length (the MaxTableNameLen property)

For more information, see the Installation and Configuration Guide.

  • [NZO-721] Updated logging configurations

The logging configurations for a particular connection can now be passed in via the connection string or DSN. For more information, see the Installation and Configuration Guide.

  • [NZO-701] Additional operating system support

The driver now supports the following additional operating systems: - Windows Server 2019 - Red Hat Enterprise Linux (RHEL) 8 - CentOS 8 - SUSE Linux Enterprise Server (SLES) 15

For a complete list of supported operating systems, see the Installation and Configuration Guide.

1.0.10 -----------------------------------------------------------------------

Released 2020-09-11

Resolved Issues The following issues have been resolved in Simba Netezza ODBC Driver 1.0.10.

  • [NZO-652] When the driver is installed on a machine that uses Turkish locale settings, if you try to connect using a connection string where one or more of the property names contains a lower-case "i" character, the driver fails to parse the string and does not connect to the server.

  • [NZO-712] When you perform an insert using parameters, and the parameter string includes a single quote ('), the driver terminates unexpectedly.

  • [NZO-712] When you perform a bulk insert using an array of parameters, the driver hangs.

1.0.9 ------------------------------------------------------------------------

Released 2020-01-08

Enhancements & New Features

  • [NZO-645] Updated Expat library

The driver has been updated to use version 2.2.9 of the Expat library. Previously, the driver used version 2.2.0.

Resolved Issues The following issue has been resolved in Simba Netezza ODBC Driver 1.0.9.

  • [NZO-691] Running queries in parallel on large amounts of data affects the driver performance.

1.0.8 ------------------------------------------------------------------------

Released 2019-11-08

Enhancements & New Features

  • [NZO-645] Standardized log file names

When logging is enabled, the driver now produces the following log files: - A simbanetezzaodbcdriver.log file that logs driver activity that is not specific to a connection. - A simbanetezzaodbcdriver_connection_[Number].log for each connection made to the database, where [Number] is a number that identifies each log file. This file logs driver activity that is specific to the connection.

  • [NZO-681] Updated OpenSSL library

The driver has been updated to use version 1.1.1d of the OpenSSL library. Previously, the driver used version 1.1.0j.

  • [NZO-667][00141891] Internal driver improvements

The driver has been updated with minor internal improvements.

Resolved Issues The following issue was resolved in Simba Netezza ODBC Driver 1.0.8.

  • [NZO-668] In some cases, when the driver reads a large amount of data, it stops responding.

This issue has been resolved. As part of this update, the default value for Prefetch Count (PreFetch) has been increased to 5000. The previous default value was 256.

1.0.7 ------------------------------------------------------------------------

Released 2019-05-20

Resolved Issues The following issue was resolved in Simba Netezza ODBC Driver 1.0.7.

  • [NZO-664] If the simba.netezzaodbc.ini configuration file is placed in the same folder as the driver library file, the driver does not read the configuration file.

1.0.6 ------------------------------------------------------------------------

Released 2019-03-27

Enhancements & New Features

  • [NZO-639] Driver-wide configurations

You can now set configuration options so that they apply to every connection that uses the driver. Before, most configuration options had to be set individually for each connection.

For information about how to set driver-wide configuration options, see the Installation and Configuration Guide.

  • [NZO-642] Updated OpenSSL library

The driver has been updated to use version 1.1.0j of the OpenSSL library.

  • [NZO-644] Updated ICU library

The driver has been updated to use version 58.2 of the ICU library.

1.0.5 ------------------------------------------------------------------------

Released 2018-10-19

Enhancements & New Features

  • [NZO-608][NZO-630] Upgrade to OpenSSL 1.1.0i

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

1.0.4 ------------------------------------------------------------------------

Released 2017-12-15

Resolved Issues The following issue was 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 issue was 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.

  • [NZO-708] The documentation incorrectly refers to "TLS/SSL version 3".

This issue has been resolved. The documentation now correctly refers to "SSL version 3".

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 ()".

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

Installation and Configuration Guide