As of Version 7 Release 7.06, the ODBC interface is no longer supported. Users must switch to JDBC.

Netezza had incorrectly implemented relational logic for a NULL value record. It had returned an unexpected unknown value. The issue was fixed by the vendor in Version 7 Release 7.0.4.

The following problem affects Netezza releases 3.0.1 through 3.0.3. Netezza will be correcting this problem beginning with release 3.0.4.

When the Netezza driver PREFETCH value is less than the number of rows fetched from an answer set, Netezza rolls back the transaction. To avoid this problem, you can do any of the following:

• Set PREFETCH to a value greater than the number of records to be fetched. The default value is 256.
• Convert the report request to several smaller sub-requests, such that each fetches fewer rows than are specified by PREFETCH.