Version and release changes in the ODBC driver behavior

This topic describes new features supported by different versions of the ODBC driver and corresponding IBM® i release.

Start of change

The following list describes some of the important changes for 7.1:

New support include the following when using the ODBC driver to access 7.1 IBM i data:

XML data type
128-byte schema names
Multiple-row UPDATE, DELETE, and MERGE statements
Concurrent Access Resolution support

End of change

The following list describes some of the important changes for V6R1:

New support include the following when using the ODBC driver to access V6R1 System i® data:

SQL query storage limits
ODBC application and QZDASOINIT system jobs association
128-byte cursor names
Decimal Floating Point (DECFLOAT) data type
Additional stored procedure date and time formats

The following list describes some of the important changes for V5R4:

There are several new features available when using the ODBC driver to access V5R4 System i data. These features include the following.

Support for 128-byte column names
Support for longer SQL statements (commands can be up to 2,097,152 bytes or 1,048,576 characters long)
Support for passing an IBM Enterprise Workload Manager™ (eWLM) correlator to the i5/OS host
Improved support for table and column names that are not all uppercase
Enhanced distributed transaction support for loosely coupled transactions
A Linux 64-bit ODBC driver