• Guru: Fooling Around With SQL And RPG

  April 15, 2024 Gregory Simmons

  Editor’s Note: This was originally scheduled to be published on April 1. No joke. And for a lot of complex reasons, that could not happen. But, it’s still fun, so enjoy.

  I started out one morning, purely interested in having a bit of fun. Honest. In RSS within ACS, I often like to run this SQL:

   select *
   from json_table(
        QSYS2.HTTP_GET('https://icanhazdadjoke.com/',
                '{"header": "Accept,application/json", "sslTolerate":"true"}'),
                'lax $' columns ("joke" varchar(200) CCSID 1208)
        )
  

  

  Okay, that was fun. This is harmless, good fun. But then I thought, what if I put this into a simple RPG program? Then I …

  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

• What the 2024 Marketplace Report Says About IBM i App Dev, Language Use

  March 13, 2024 Alex Woodie

  What languages, development environments, and tools are IBM i developers currently using to create new applications? How many users are still on SEU? And how are VS Code and Merlin faring among Web-based development tools? Fortra sought to answer those questions with its IBM i Marketplace Survey for 2024, and the results may surprise you.

  In late 2023, Fortra surveyed 270 IBM i professionals from around the world for the 2024 IBM i Marketplace Survey, which it published in January. You can download the report here.

  For the most part, Fortra asks the same questions every year, which is …

  Read more

• If It Ain’t Broke, Don’t Fix It

  March 13, 2024 Alex Woodie

  The information technology industry has a “newness” bias. It always has, and probably always will. But when it comes to the systems for processing business transactions, decision makers need to think carefully about what they’re doing, as ditching “legacy technology” for a shiny new one doesn’t always deliver the promised upgrade.

  The cloud is currently the hot new thing in IT. Even though it’s not necessarily “new,” and not necessarily “a technology” (it is a collection of technologies and a platform and a business model…), business owners are under tremendous pressure to “get to the cloud” by whatever means necessary. …

  Read more

• More Db2 Web Query Alternatives, And An Update

  March 11, 2024 Alex Woodie

  It has been five months since IBM abruptly killed off Db2 Web Query, the IBM i-based suite of business intelligence tools that Big Blue OEMed from Information Builders. Some customers have already settled on a replacement, but many others are still combing the market looking for a good fit.

  The product that is arguably the most well-positioned to replace Db2 Web Query is WebFOCUS, the Information Builders product on which Db2 Web Query is based. IBM had an OEM agreement with the New York-based company for more 15 years before it abruptly ended in October.

  IT Jungle has asked Information …

  Read more

• PUB400: Your Free IBM i Playground

  March 4, 2024 Alex Woodie

  Search the Web for “free Linux server” and hundreds of results pop up. Do the same for “free IBM i server” and your results are much more limited. But what the universe of free IBM i servers lacks in quantity it makes up in quality thanks in large part to PUB400, a free IBM i instance that has been serving the midrange community for nearly a quarter century.

  Many IT Jungle readers undoubtedly are familiar with PUB400.com, which was started by Holger Scherer on a little AS/400 Model 150 back in 1999. Over the years, the site and the …

  Read more

• Guru: Assertions, Take 2

  February 12, 2024 Ted Holt

  It’s been almost 20 years since Cletus the Codeslinger introduced assertions to the IBM midrange world, and in that time, I have included many assertions in my RPG programs. During that 20 years, RPG has changed a bit and Cletus has quit writing articles (but not source code), so I’ve taken it upon myself to update the code he gave us.

  First, however, it might be a good idea to briefly review the topic of assertions for readers who don’t know what they are. An assertion is a program statement or command that cancels a program if a fatal condition …

  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

• Guru: Getting Started With The Code 4 i Extension Within VS Code

  January 22, 2024 Gregory Simmons

  The Code for IBM i extension is growing in popularity and has certainly become my favorite source code editor. This article is not an attempt to convince you to drop RDi and switch to VS Code. Rather, I aim to share with you a few of my favorite settings and features in VS Code.

  Join In The Discussion

  Can’t figure out how to do something? Have a suggestion for a new enhancement? I am continually impressed with the speed at which I get responses when I post something. The team of coders and contributors to the Code for IBM i …

  Read more

• 2024 IBM i Predictions, Part Deux

  January 22, 2024 Alex Woodie

  How will 2024 unfold? Nobody knows the answer to that. But that’s not stopping members of the IBM i community from taking some swings. It’s not only a good Bayesian exercise to think through the probabilities of what may occur, but it’s often a bit of fun, too.

  Our second batch of 2024 predictions starts with IBM distinguished engineer Steve Will, who, as the IBM i chief technology officer and IBM i chief architect, doesn’t need to guess where the platform is going, since he’s literally leading the creation of it. Instead, his prediction focuses on the community.

  “2024 will …

  Read more

Previous Articles Next Articles