• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Guru: Creating An SQL Stored Procedure That Returns A Result Set

    May 12, 2025 Mike Larsen

    Continuing to build out the stored procedure series, I’m going to show how to create an SQL stored procedure that returns a result set. This is very similar to the previous article where I showed how to do this using RPG. In this example, we’re just using pure SQL to achieve the same results.

    I created an SQL script (Figure 1) that selects all rows from the Departments table. The SQL statement is the same as the one I used in the RPG program from the prior article, but I’ll describe it again here. I didn’t add any selection criteria …

    Read more
  • Guru: Creating An RPG Stored Procedure That Returns A Result Set

    March 17, 2025 Mike Larsen

    In the previous article, I showed how to create an RPG stored procedure that uses parameters. In this article, I’m going to show how to create an RPG stored procedure that returns a result set, as we would likely encounter this scenario more frequently. The data used in this example comes from the Department table from IBM’s Sample database.

    I created an RPG program (Figure 1) that selects all rows from the Departments table. I didn’t add any selection criteria as I know there aren’t many rows in the table, but you may want to limit the number of rows …

    Read more
  • Guru: AI Pair Programming In RPG With Continue

    March 10, 2025 Gregory Simmons

    In my last article, I shared a brief introduction to the GitHub Copilot extensions. These extensions provide an easy way to get up and running with an AI coding assistant to aid you in your RPG development. Being cloud based, it’s lightweight in terms of system resources, but it does cost a little money per month, per user.

    For this article, I would like to share with you what I have learned about a newer extension for VS Code named Continue. Continue runs locally on your PC, is 100 percent free, and as of this writing, is the leading …

    Read more
  • Guru: AI Pair Programming In RPG With GitHub Copilot

    February 17, 2025 Gregory Simmons

    If you have been meaning to give VS Code a try, but just haven’t had a chance, I encourage you to avail yourself today. Yes, for you RDi users, it will take a little bit to migrate your favorite settings, code snippets, and compile commands – but I promise, you won’t regret the move.

    In my article, Getting Started With The Code 4 i Extension Within VS Code, I offer a few more insights to help get you started. And if you are an SEU user, yes, the switch may seem daunting, but one of the great things about …

    Read more
  • Beta For RPG Coding Assistant On Track for 2Q25

    January 20, 2025 Alex Woodie

    IBM is ramping up development of the AI-based RPG Code Assist and expects to have a working prototype ready for testing by the end of the first quarter, IBM i chief technology officer Steve Will said in a webinar last month. The goal is to have a beta ready for during the second quarter and general availability hopefully in the second half of the year, he added.

    Large language models (LLMs) such as OpenAI’s GPT and Google’s Gemini have taken the world by storm, and companies are investing tens of billions of dollars in the nascent tech to gain …

    Read more
  • IBM’s Fall 2024 Code for IBM i Enhancements

    November 13, 2024 Alex Woodie

    Adoption of Code for i continues to soar among IBM i developers, as they shift from heavy, expensive integrated development environments (IDEs) to lighter, open-source options. With the latest Technology Refreshes (TRs) for IBM i, IBM is making the VS Code plug-in even more useful for RPG and COBOL developers.

    Code for IBM i is the brainchild of Liam Allan, the midrange wunderkind with an intense aversion to Rational Developer for IBM i (RDi), IBM’s Java-based flagship IDE for IBM i. As adoption of the VS Code extension grew in the summer of 2022, IBM smartly hired Allan as a …

    Read more
  • How To Have The Wisdom Of Experts Woven Into Your Code

    October 14, 2024 Nicholas DeLessio

    No matter how far you are down the road with your DevOps automation journey, or even if you’re not yet starting that journey, it’s probably a good idea to have a code checker; not everyone can have a Linus Torvalds review their work (as famously happens with the open source Linux kernel), but there are automation tools available for various languages and platforms that do static code analysis and they are the next best thing.

    These tools, sometimes called “code linters” (because they remove the fuzzy bits out of application logic like actual linters remove imperfections stuck to our clothing), …

    Read more
  • The Many Faces Of IT Modernization

    October 7, 2024 Alex Woodie

    The clarion call of modernization has been heard loud and clear among IBM i and System z shops for decades. Old IT is hampering your competitiveness, they’re told, and something must be done about it. In reality, there’s no single path to modernization, which is a multi-faceted phenomenon that can have wide ranging impacts on the business, Rocket Software says in a new report.

    Business transformation is separate from IT transformation, but the two are linked, according to Rocket Software’s new study, titled IT Modernization Without Disruption, which is based on a survey of 309 decision-maker at System …

    Read more
  • Remain Bolsters Development Options with TD/OMS

    September 18, 2024 Alex Woodie

    Remain Software recently rolled out a major upgrade to its change management software for IBM i. The big enhancements with TD/OMS 16.1 include the availability of Remain’s Web-based development framework, dubbed Octo, as well as support for the popular Web-based IDE, VS Code.

    Remain Software introduced Octo more than two years ago as a lightweight Web-based framework to unite its various IBM i offerings. Short for Open Core for Technology Orchestration, Octo was initially put forward as a way to integrate and display information from other Remain Software applications, such as TD/OMS, Gravity, API Studio, and MiWorkplace, its lightweight, Web-based …

    Read more
  • Untangling Legacy Spaghetti Code To Cook Up Microservices

    August 12, 2024 Michel Mouchon

    At this point in the history of programming, everyone pretty much knows what microservices are and everybody is more than acquainted with the legacy code – and often monolithic code – that has been created over decades by countless programmers who have evolved corporate applications to fit new conditions and new demands.

    It is often called spaghetti code, and for good reason. The code is often a tangled mess of business logic and data – presumably the data is the meatballs and the user interface is the sauce in this metaphor. (It is important to not take a metaphor too …

    Read more

Previous Articles Next Articles

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • The Power11 Transistor Count Discrepancies Explained – Sort Of
  • Is Your IBM i HA/DR Actually Tested – Or Just Installed?
  • Big Blue Delivers IBM i Customer Requests In ACS Update
  • New DbToo SDK Hooks RPG And Db2 For i To External Services
  • IBM i PTF Guide, Volume 27, Number 33
  • Tool Aims To Streamline Git Integration For Old School IBM i Devs
  • IBM To Add Full System Replication And FlashCopy To PowerHA
  • Guru: Decoding Base64 ASCII
  • The Price Tweaking Continues For Power Systems
  • IBM i PTF Guide, Volume 27, Numbers 31 And 32

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle