IBM i Access for Linux allows customers to access DB2 for i using its ODBC driver, execute IBM i commands with the rmtcmd utility, establish 5250 sessions, and utilize library and headers to build custom applications that communicate with an IBM i host.
IBM i Access for Linux 7.1 now provides:
- ODBC support of 128-byte schema names
- ODBC support for the IBM i XML Data Type
- ODBC support of Concurrent Access Resolution
- ODBC support for multi-row UPDATE, DELETE, and MERGE statements
- Updates to the emulator, connectivity enhancements and several NLS-related fixes
System i Access for Linux allows customers to access the DB2 for i5/OS using its ODBC driver, execute IBM i commands with rmtcmd utility, establish 5250 sessions, and provide library and headers to build custom applications that can easily communicate with an i5 host.
System i Access for Linux 6.1 now provides:
- Remote Command Unicode API Support — The remote command Unicode interface cwbRC_RunCmdW now flows Unicode data to IBM i. IBM i must be at V6R1, or later.
- IPv6 support for ODBC, Remote Command and other utilities (emulator is not IPv6 enabled)
- ODBC handle stored procedures compiled with different date/time format — No matter which date/time format is used when you create the procedure, the result sets return the date/time format specified when executing the procedure.
- ODBC extended indicator support — INSERT and UPDATE SQL prepared statements do not require the user to specify a value for each field used in the sentence. Instead, you can specify an indicator to use the default value for a specific field or to ignore the field in the sentence. This enhancement can increase performance and offer a better way to use prepared statements.
- ODBC increased length of statement and cursor names to 128 characters — With this change, application providers can generate unrepeatable cursor names easily and with more space to better name the cursors.
- ODBC query storage limit — You can set parameter QRYSTGLMT to specify a storage limit for a query. This parameter prevents execution of a query by comparing the specified storage limit with the estimated storage usage of the query. This new ODBC driver sets the parameter in the connection string.
- ODBC DB2 support for decimal float data type
System Access for Linux V5R4 supports additional 64-bit platforms (PowerPC-64 and x86-64). There are two packages available:
- 32-bit package: includes the 5250 emulator, the ODBC driver, and the Extended Dynamic Remote Support (EDRS) driver
- 64-bit package: includes the ODBC driver and EDRS driver but not the 5250 emulator
The EDRS driver is only available with V5R4 System Access for Linux and not earlier versions. The V5R4 product is supported connecting to V5R4 and V5R3 i5/OS, and V5R2 OS/400.
Version 1.4 of iSeries Access for Linux includes several font issues addressed for Russian, Chinese, German and Japanese languages.
Installation: The installation instructions can be found in the IBM i Access for Linux section of the IBM i Information Center.