IBM i Services are a growing, innovative use of SQL on the IBM i platform. These services are SQL-based functions and views that provide convenient access to system functionality. For example, VS Code for i uses the LIBRARY_INFO table function.
Because these SQL-based services are added and enhanced over time, each service has an operating system release and Group PTF level at which it became available. Our LIBRARY_INFO example was provided in IBM i 7.3 with Group PTF SF99703, Level 18, and enhanced with SF99703 Level 22. For IBM i 7.4, it was SF99704, Level 7, and enhanced with SF99704 Level 10. Starting with IBM i 7.5, LIBRARY_INFO no longer required a Group PTF.
I had wished there was a list of minimum release levels for all the IBM i Services. As it happened, at our latest Code for IBM i Fridays meeting, Scott Forstie, the DB2 for i Business Architect, provided the resources that I’d been looking for.
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2025-04-25 12:46:172025-04-25 12:46:17Release Levels for IBM i Services (SQL)
We’ve been hearing from clients wondering whether they need commercial connectors to integrate open source technology with Db2, RPG, and COBOL data.
Liam Allan has shown the power of using open source tools that are available to everyone. He recommends accessing IBM i business logic and data using open source tools, without proprietary connectors.
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2021-05-12 12:12:342021-05-12 19:09:48Tutorial: Integrate Node.js with RPG without a Connector
We regularly turn to the IBM i (SQL) services that Scott Forstie’s team at IBM has been delivering. We love using them to get specific jobs done faster!
What’s not to love? SQL is a universal interface, based on IBM i’s revered crown jewel, Db2 for i. Code once, use many times from every conceivable kind of technology—on the box and off. Brilliant!
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2020-08-03 09:57:562020-08-03 15:32:209 Smart Ways to Use IBM i Services
Scott Forstie (left) with Alan Seiden at a previous CIO Summit
In recent years, Db2 for i Business Architect Scott Forstie and his team have rapidly strengthened the IBM i database, improving the sophistication of its SQL query engine, and adding to its galaxy of IBM i services. What’s more, they have several years’ worth of new enhancements in the pipeline.
CIOs and IT Directors can meet Scott at the CIO Summit on March 25, 2019, Charlotte, North Carolina, for an IBM i strategy briefing.
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2019-01-22 15:54:142019-01-30 15:37:40CIO Summit Features DB2 for i Briefing with IBM’s Scott Forstie
The ever-expanding capabilities of Db2 for i can simplify development in open source languages such as PHP, Ruby, Node.js (JavaScript), and Python. These languages, known for their effectiveness in building web and mobile applications, can tap into the power of SQL.
So why complicate them with repetitive code that distracts from their power and simplicity?
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2018-10-24 13:21:012018-10-30 09:52:59Db2, SQL, and Open Source Languages on IBM i
Now that speedy PHP 7 is available for IBM i, we’ve been helping clients upgrade to this long-awaited release. Here are some resources for performing this popular upgrade.
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2017-07-24 12:11:242021-02-24 17:45:04Resources for Upgrading to PHP 7 on IBM i
It’s not always easy to locate the official documentation for all features of DB2 for IBM i. Using Google Search is hit or miss, with full-text searches often bringing irrelevant results from other varieties of DB2 or from older versions. Many people don’t know that complete reference manuals are available for almost every aspect of DB2 on i.
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2017-06-23 09:28:152020-06-25 12:38:30Where to find DB2 for IBM i documentation
In just two weeks I’ll have the pleasure of joining some of the top IBM i development experts in Orlando for the RPG & DB2 Summit. Run by Susan Gantner, Jon Paris and Paul Tuohy, this conference is full of big personalities who create a warm, friendly environment that’s perfect for learning.
I enjoy the community feeling and how excited everyone is to solve development problems and share tips and techniques.
The RPG & DB2 Summit is one of the few training events that focuses exclusively on topics of interest to IBM i developers. That includes PHP and SQL, of course!
Check out the session grid and pay special attention to the Hands-on PHP Workshop on Monday, March 20, followed by several PHP and open source sessions given by yours truly and Zend’s Mike Pavlak, plus a whole array of SQL sessions. And maybe a few on RPG.
I think they should change the name of the conference to the RPG, PHP, SQL & DB2 Summit, don’t you?
Come join us!
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png00Alan Seidenhttps://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.pngAlan Seiden2017-03-06 22:44:332017-05-14 18:19:10RPG & DB2 Summit: March 21-23, 2017, in Orlando