Pairing open source with traditional IBM i programs works great for APIs, web, and mobile applications. But how do you stay on top of your business’s requirements for speed and scalability?
OCEAN User Group recently asked Alan to help answer that question. In the recording of their November meeting (also linked from the graphic below), he covers:
Since IBM announced Yum support for installing the IBM i Db2 ODBC driver, as documented in our 2022 tutorial, users can update their driver more easily.
To help users determine what’s changed, IBM maintains a list of fixes and enhancements for each IBM i ODBC driver release.
Open source on IBM i is moving fast these days. Alan recently shared his favorite updates to IBM i open source—focusing on improved security, performance, and ease of programming—at a Summit Lunch & Learn hosted by Paul Tuohy.
Open source continues to gain traction in IBM i shops, and for good reason. It excels at delivering new interfaces and functionality for RPG and COBOL applications, plus it broadens the talent pool for your development team.
When querying for character data using SQL, case matters. “A” is not equal to “a”. Even so, you might want to find all matches, whether uppercase, lowercase, or mixed case.
ODBC connections between Linux and IBM i should be encrypted to keep their Db2 data safe in transit.
To encrypt ODBC data, IBM recommends the industry-standard TLS encryption protocol (the successor to SSL).
Since IBM announced Yum support for installing the IBM i Db2 ODBC driver, as documented in our recent tutorial, users can update their driver more easily.
To help users determine what’s changed, IBM maintains a list of fixes and enhancements for each IBM i ODBC driver release.
The IBM i ODBC driver for Db2 has become easier to install.
Formerly available only as a download requiring several steps, the driver can now be installed and updated on IBM i with Yum or Access Client Solutions (ACS), as easily as with other IBM i open source packages.
Here are instructions for installing the ODBC driver using Yum.
As ODBC gains popularity for IBM i database access, developers of web applications and APIs need information on defining ODBC database connections. This article demonstrates tips and techniques for effectively using ODBC connection strings in all programming environments, including popular languages such as PHP, Python, and Node.js.
For an example of how connection strings are used in a program, see How to Query IBM i Data with PHP and PDO_ODBC.
Of the PHP extensions that can connect to IBM i Db2, PDO_ODBC is the most flexible.
Although the classic extensions (ibm_db2, PDO_IBM) often provide the best performance and integration, PDO_ODBC does have several benefits:
Read more →