Standards and specifications conformance

The IBM® Netezza® drivers and providers conform to certain standards and specifications.
The Netezza ODBC drivers support the Microsoft ODBC Version 3.0 and 3.5 specifications and international standards for the SQL Call Level Interface (SQL CLI) on Windows, UNIX, and Linux® systems. The international standards are as follows:
  • The X/Open CAE Specification Data Management: SQL Call Level Interface (CLI)
  • ISO/IEC 9075-3:1995 (E) Call Level Interface (SQL CLI)

The X/Open and ISO/IEC standards for the SQL CLI are published in separate documents, but the two standards are closely aligned. The Microsoft ODBC specifications are closely aligned with the X/Open, ANSI, and ISO/IEC international standards for the SQL CLI. For information about the Microsoft ODBC implementation of the SQL CLI standards, see http://msdn.microsoft.com/en-us/library.

The Netezza JDBC driver was tested for conformance with Version 4.1 of the Oracle JDBC API specification on Windows, UNIX, and Linux systems. For a list of unsupported methods, see Unsupported JDBC methods. For information about the Oracle Sun Developer Network JDBC implementation of the SQL CLI, see http://java.sun.com/reference/api/index.html.

The Netezza OLE DB provider supports Microsoft OLE DB Version 2.7 on Windows systems. For information about the Microsoft OLE DB implementation, see http://msdn.microsoft.com/en-us/library.

The Netezza .NET Provider is supported on Windows systems and is based on the ADO.NET 3.0 data provider specification. For a list of unsupported methods and properties from that specification, see Unsupported ADO.NET methods and properties.