• IBM Cranks Up the Performance for Run SQL Scripts

  April 24, 2024 Alex Woodie

  Access Client Solutions (ACS) users who are tired of waiting for database fields to resolve in the Run SQL Scripts (RSS) facility will be happy to hear that IBM felt their pain and RSS will return data much more quickly to return data with ACS version 1.1.9.5, which IBM shipped earlier this month.

  The speed-up of field resolution time was listed as a concern to at least one IBM i user, who took to IBM Power Ideas Portal to voice his or her concern. “Simply put the resolution of potential field makes content assist almost unusable,” the user wrote. “I …

  Read more

• Guru: Web Concepts For The RPG Developer, Part 1

  April 22, 2024 Chris Ringer

  Way back in the 1990s, I recall accessing data with only RPG III F-Specs. But nowadays some of that critical data may live in the cloud. The good news is tools like HTTPAPI and RXS and SQL functions like SQL HTTP are available to access that remote data from the IBM i. But what you may not know is how to actually format components in those HTTP requests.

  Here I will discuss some techniques to build those components in an HTTP request before sending it across the web.

  HTTP Get Versus Post

  The two most common methods for an HTTP …

  Read more

• 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 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

• 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

• 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

• Thoroughly Modern: Practical Ways IBM i Developers Can Use AI Today

  December 4, 2023 Scott Gingerysty

  This October at COMMON’s NAViGATE Conference, I presented a session about practical ways that IBM i developers can use AI in their day-to-day development practices. We discussed how you can streamline and optimize the development process, improve coding velocity, enhance code hygiene, testing and documentation, and we also looked at some of the caveats. After connecting with the folks at COMMON – and seeing their enthusiasm – I felt inspired to share these examples with the IT Jungle community.

  So, why AI for developers? AI offers a transformative toolkit that streamlines learning and amplifies creative problem-solving. Through machine learning algorithms, …

  Read more

• Guru: Partitioning Result Sets Using SQL

  November 27, 2023 Mike Larsen

  While working on a project recently, I needed to retrieve attributes of an item. While that sounds like a simple task, there was a twist. While reviewing the contents of the item master table, I noticed there could be multiple rows for the same item and each row was active and valid from a business perspective.

  I won’t get into the business end of it, but my goal was to return the most recent iteration of the item for further processing in the program. After doing some research and trying some potential solutions, I came across the SQL partition by …

  Read more

Previous Articles Next Articles