• IBM Improves Run SQL Scripts with ACS Update

  September 22, 2021 Alex Woodie

  In recent years, Access Client Solutions (ACS) has become an indispensable utility for a range of tasks involving the IBM i. A good reason for that success is the adoption of Run SQL Scripts, which has been enhanced with the latest Technology Refresh for IBM i 7.3 and 7.4.

  ACS is a Java-based product that IBM first unveiled in 2012 and that has replaced other versions of Client Access, including the dedicated Windows utility. No matter what type of computer or device you’re using to work with the IBM i server, be it Windows, Linux, or Mac, you can access …

  Read more

• Want to Talk IBM i OSS? Head Up the Ryver

  September 1, 2021 Alex Woodie

  The world of open source moves quickly, and it’s no different on the IBM i platform, where open source is being rapidly adopted by companies large and small. IBM i professionals who want to keep up to speed with the latest may want to check out a community of IBM i open source enthusiasts that was created on Ryver.

  Ryver (pronounced “river”) is a next-gen communications portal that’s taking on Slack, Microsoft Teams, and others. Like chatrooms and mailing lists, Ryver allows people to have open discussions, as well as private chats and focused conversations. There is also the …

  Read more

• Calling All IBM i Platforms. . .

  August 16, 2021 Daniel Magid

  In a microservices world, all elements of what used to be monolithic application programs are now chunks of code linked to each other using any number of application programming interfaces, or APIs. Those APIs can be based on a remote procedure call, or RPC, architecture, which is a kind of generic distributed client/server approach, or the REST – short for representational state transfer – architecture favored by parts of the commercial Web software stack that has dramatically grown in popularity in the past two decades. Either way – and in fact, there are more than two ways – APIs are …

  Read more

• PHP Decisions Loom as Original Distro Reaches End of Life

  May 24, 2021 Alex Woodie

  IBM i shops have five more weeks until Zend Server Basic, the PHP runtime used by thousands of IBM i shops over the years, reaches end of life and will no longer be offered, supported, or updated with security fixes. Customers that want to continue using PHP safely beyond July 1 will need to obtain a new license or move to a new PHP runtime.

  The long history of Zend Server Basic stretches all the way back to 2006, which was the year when the PHP runtime became one of the first open source technologies to be adapted to run …

  Read more

• Guru: A Simple Script That Capitalizes on IBM i’s Open Source Capabilities

  April 26, 2021 Rob McNelly

  In my last piece, we got Yum and Bash running on IBM i. Now let’s build on that foundation to find an open campsite.

  I’m serious. Recently I used an IBM i LPAR to schedule a hiking and camping trip to the Grand Canyon. Where to begin? My bio, perhaps. Here it’s mentioned that “Rob enjoys camping, hiking, biking, and backpacking through the mountains of Arizona. . . . His favorite trip was hiking to the blue waters of Havasupai, and he is planning on hiking the Grand Canyon in the near future.”

  So last summer I went …

  Read more

• Guru: Getting Yum And Bash Up And Running

  March 15, 2021 Rob McNelly

  In the March 1 edition of The Four Hundred, I noted that an emphasis on things like system/application modernization and open source solutions gives IBM i newcomers a degree of comfort with the platform. I also made the point that no matter how long you or I have been at this, there are always people, young or not so young, who are new to the platform and come to this site seeking introductory information about various tasks and capabilities.

  With this in mind, I want to delve further into open source for those who are new to it. As …

  Read more

• Zend Server for IBM i Now 64-Bit, Available Via RPM

  January 20, 2021 Alex Woodie

  IBM i shops can now get Zend Server for IBM i via RPM, which has become the standard method for obtaining and installing open source software on the IBM i platform. The enterprise-grade PHP runtime for IBM i also now runs in 64-bit mode, according to Perforce, the owner of the Zend PHP products.

  According to the release notes for Zend Server 2020 for IBM i, the new release brings a host of new features, changes, and fixes to the product. Among the biggest changes is the adoption of RPM packaging for all components, including the IBM i specific ones …

  Read more

• MariaDB Now Available Via RPM

  December 7, 2020 Alex Woodie

  When it comes to databases for the IBM i community, Db2 for i is, and always be, number one. But there’s no reason to limit yourself to just one database, and now IBM is making it easier for IBM i shops to get their hands on MariaDB, which could be the number two database on the platform.

  MariaDB is an open source relational database that is a fork of MySQL. MySQL, of course, has been supported on the IBM i server for many years. But following Oracle’s acquisition of Sun Microsystems, which had acquired the company that developed MySQL, …

  Read more

• Open Source The Path To Software Riches For IBM i

  December 2, 2020 Alex Woodie

  For what is supposed to be a proprietary platform, the IBM i server sure has a lot of open source software running on it. In recent months, it appears that the majority of new programs introduced to IBM i are open source in nature. That pattern shows no signs of changing any time soon, according to a recent report by OpenLogic.

  Open software has existed on the IBM i platform for many years. The first highly publicized dip into the open source well occurred in 2005, when IBM partnered with a company called Zend to bring its PHP runtime to …

  Read more

• IBM Rolls Out ACS 1.1.8.5

  August 12, 2020 Alex Woodie

  IBM last week introduced a new release of Access Client Solutions (ACS), the popular IBM i client that’s used by administrators, programmers, and engineers alike. There are enhancements to Run SQL Scripts, new 5250 viewing options, and a performance boost for viewing selected files on the IFS with version 1.1.8.5, among other mostly minor updates.

  According to the release notes associated with the new iteration of ACS, IBM made a handful of changes with version 1.1.8.5.

  Let’s start with the improvements to Run SQL Scripts, which is an increasingly popular utility in ACS that leverages the power of SQL and …

  Read more

Previous Articles