• What Do IBM i Shops Use To Write Applications These Days?

  February 3, 2025 Alex Woodie

  When it comes to languages and tools for developing applications on IBM i, there are a ton of options available for customers. Thanks to the PASE runtime, a variety of open source languages and runtimes have been brought to the platform, not to mention the time-tested ILE technologies from IBM. But what do IBM i shops actually use to write new apps? For answers, we look to Fortra’s 2025 IBM i Marketplace Survey results.

  Fortra recently released the results for the 11th installment of its IBM i Marketplace Survey, which is based on surveys it conducted in late 2025 …

  Read more

• Precisely Streams IBM i Data Into Amazon’s New Db2 Service

  April 8, 2024 Alex Woodie

  Amid the torrent of news that Amazon Web Services unveiled at its re:Invent show four months ago was RDS for Db2, a new hosted relational data service based on IBM’s database. Amazon Web Services offers the Linux, Unix, and Windows (LUW) variant of Db2, but thanks to a new connector unveiled by Precisely last week, IBM i and mainframe shops have a way to replicate their data into it.

  Amazon RDS is among the cloud giant’s most popular services, and likely one of the most popular IT services ever created. According to one estimate, Amazon RDS brings in $7 billion …

  Read more

• What’s Up with Open Source on IBM i?

  March 27, 2024 Alex Woodie

  Open source software has become a steadfast component of the IBM i stack. But what open source software are IBM i shops using today? Results from Fortra’s recent IBM i Marketplace Survey provide answers.

  It may seem odd now, but open source hasn’t always been a staple of the IBM i server’s software diet. Until PHP arrived on the platform two decades ago, proprietary software was the only option for IBM i shops.

  But today, IBM i shops have hundreds of open source products to choose from. Thanks to the IBM i server’s openness, just about any product that can …

  Read more

• RPG Training Program Spun Up by Trucking Industry Outsourcer

  February 7, 2024 Alex Woodie

  If you’re in the trucking business and need RPG programmers, you might want to check out the outsourcing firm DDC FPO, which has spun up a new program in the Philippines to train junior RPG programmers to work at American trucking firms.

  DDC FPO is one of the country’s largest business process outsourcing (BPO) firms serving the trucking industry. The company, which is headquartered in Evergreen, Colorado, works with more than half of the country’s less-than-truckload (LTL) operators. About one-third of the bills of lading generated daily are generated by DDC FPO workers, the company claims.

  The IBM i platform …

  Read more

• IBM i Shops Have Alternatives to Db2 Web Query

  November 15, 2023 Alex Woodie

  The sudden demise of Db2 Web Query has sent customers looking for alternatives. The good news is that IBM i software vendors offer a number of pre-built solutions that can fit the bill.

  Here are some potential business intelligence tools from vendors that could serve as replacements to Db2 Web Query. We’ll take a look at open source alternatives in a future article.

  Cozzi Research SQL World

  Cozzi Research develops two query tools for IBM i, including SQL iQuery and SQL Tools, and bundles them both in a single product called SQL World.

  Cozzi positions SQL iQuery as a native …

  Read more

• Rimini Supports IBM i Environments with New Outsourcing Biz

  May 10, 2023 Alex Woodie

  Rimini Street’s new outsourcing business, Rimini ONE, supports IBM i application environments, the company confirmed to IT Jungle. In addition to delivering application support services for JD Edwards and SAP running on IBM i, the Las Vegas company is also offering to manage the full stack of technology upon which these ERP systems run.

  Rimini Street has provided third-party support and maintenance services for a variety of ERP systems for over a decade. You may have recalled the epic legal battle it waged with Oracle, which accused the company of stealing its intellectual property in pursuit of its …

  Read more

• Entry Servers: IBM i Versus Windows Server, Redux

  April 10, 2023 Timothy Prickett Morgan

  No comparison between similar but different things is ever perfect. It is the nature of language, constructed of similes and metaphors, as well as science, which speaks in generalities but craves ever-finer precision. It is no different when trying to compare different system platforms, which we do quite often around here at The Four Hundred and have for three and a half decades.

  The comparison between the Power S1022s running IBM i and a Dell PowerEdge R7515 running Windows Server and SQL Server, which we did last week, needed some refinement, I learned from an intrepid reader who reminded …

  Read more

• Altova Updates Db2 for i Support Across Product Line

  July 14, 2021 Alex Woodie

  IBM i shops that use data and development tools from Altova will be happy to know that the software vendor has added support for the latest release of Db2 for i among several of its tools.

  Altova is a Beverley, Massachusetts, company that develops a series of software tools and utilities for developers. The company is arguably best known as the creator of XMLSpy, an IDE that allows developers to create XML-based Web services using standards like WSDL; it later added support for JSON data and the modern SOAP protocol.

  In 2010, Altova added support for IBM i in MissionKit, …

  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: Date Format Confusion

  May 10, 2021 Ted Holt

  Hey, Ted:

  I use the Copy to Import File (CPYTOIMPF) command to build a CSV file to be sent to a MySQL system. My colleagues are unable to import the file because of the format of a timestamp field. CPYTOIMPF puts a hyphen between the date and time (e.g. 2021-05-10-04.36.24.849555), but the other system wants a space between them. Other than writing a custom program do you know of another way to change the format of the timestamp output?

  — Richard

  You won’t need a custom program, Richard. There’s another way to handle this requirement.

  IBM has already very thoughtfully …

  Read more

Previous Articles