- 701. Advanced/Free - Function Calls and Return Values
- (RPG)
- Even though we have used /Free to build some ILE programs, there are still a few more tricks for you to learn about the latest iteration of RPG. By David Shirey Editor's Note: This article is excerpted ...
- Created on 01 April 2024
- 702. Node.js on IBM i: System Access and DB2 Database Access
- (Programming - Other)
- ... Python, and PHP. The RPG program calls should be just as familiar: I am going to post the output as well because it will help you to understand the structure of the objects above. Remember, we ...
- Created on 11 March 2024
- 703. SQL 101: DDL Recap—From Physical Files to SQL Tables, Starting the Journey
- (SQL)
- ... was extracted—essential for keeping RPG programs that use this table functioning without modification. Also notice the comment line just below the first line of the statement: This is the database engine’s ...
- Created on 04 March 2024
- 704. PRACTICAL ILE - ILE Service Programs
- (RPG)
- ... from article 9 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. Service programs are a natural part of ILE and the culmination of what it promises. And the drawback? Well, I guess it would ...
- Created on 04 March 2024
- 705. Node.js on IBM i: Vexing Versions
- (Programming - Other)
- ... to explore them here. But this can give you an idea, at least, of what it would take: This is a package.json file from a project I have at GitHub (https://github.com/phelgren/rpg-node). You can see ...
- Created on 12 February 2024
- 706. A Retrospective of IBM i at 35
- (Programming - Other)
- ... on a wiring board (an early version of RPG?). IBM 1401 In those early days colleges did not offer any curriculum for information technology. Most employers who were implementing computer systems had ...
- Created on 15 January 2024
- 707. Introducing Kato Spaces: The New Name for Your Trusted IBM i Cloud Hosting Solution
- (Cloud News)
- ... built in 100% RPG for general use, address tools, UPS connectivity, and CyberSource payment processing. What's Next? The transition to Kato Spaces will be smooth and seamless. All existing contracts, ...
- Created on 02 January 2024
- 708. Node.js on IBM i: Arrays and Hashes
- (Programming - Other)
- ... first take a look at arrays because I think they will be pretty familiar to RPG programmers and programmers in general. In JavaScript we can construct an array in one of a couple of ways: Like most ...
- Created on 08 November 2023
- 709. Data-Manipulation Operations Using Free Format, Part Two
- (RPG)
- RPG IV provides a rich set of built-in functions, many of which target data manipulation tasks. Read Part One. By Jim Martin Editor's Note: This article is excerpted from chapter 8 of Free-Format RPG ...
- Created on 31 October 2023
- 710. Data-Manipulation Operations Using Free Format, Part Three
- (RPG)
- RPG IV provides a rich set of built-in functions, many of which target data manipulation tasks. Read Parts One and Two. By Jim Martin Editor's Note: This article is excerpted from chapter 8 of Free-Format ...
- Created on 31 October 2023
- 711. Practical SQL: More Change Management
- (SQL)
- ... and only if that module’s name matches the program name. For simpler ILE environments, where you have a single source member for a program and use commands like CRTBNDRPG or CRTBNDCL (or CRTBNDCBL for ...
- Created on 24 October 2023
- 712. Data-Manipulation Operations Using Free Format, Part One
- (RPG)
- Data, it seems, is never quite in the form we need. We perform operations on our data to convert it to the form we want. Free-format RPG IV offers a variety of methods for transforming data to suit our ...
- Created on 03 October 2023
- 713. Media Kit - 2024
- (General Content)
- ... Wednesday of every month. MC Systems Insight, MC RPG Developer and MC TNT Tips ‘n Techniques. . Audience size is approximately 8,928, 9,919, and 8,377 respectively. Call for latest list size. a) Exclusive ...
- Created on 21 September 2023
- 714. Embedded SQL Operations Using Free Format
- (RPG)
- Embedded Structured Query Language (SQL) has been available to the RPG programmer for a long time. By Jim Martin Editor's Note: This article is excerpted from chapter 7 of Free-Format RPG IV: Third ...
- Created on 08 August 2023
- 715. PRACTICAL ILE - ILE: Calling One Program from Another
- (RPG)
- ... RPG: /Free, ILE, and MVC, by David Shirey. Back in the olden days, we would have used a CALL with a PARM list. But the regular, old CALL was not carried over into /Free. It wasn’t efficient enough. And ...
- Created on 04 August 2023
- 716. Practical SQL: Prepared Statement Magic
- (SQL)
- ... first issue is that embedded SQL won’t let us use variables to define table and column names (file and field name to us RPG folks). This will not work: EXEC SQL 'SET :FACOUNT = (SELECT COUNT(DISTINCT ...
- Created on 04 August 2023
- 717. Program Flow Using Free Format, Part 2
- (RPG)
- The Do Operations - Free-format RPG IV provides two Do operations: Dow (Do while) and Dou (Do until). For Part One of this article set read here. By Jim Martin Editor's Note: This article is excerpted ...
- Created on 17 July 2023
- 718. PRACTICAL ILE - ILE Subroutines to Sub-Procedures
- (RPG)
- Why Subroutines Cause Blindness By David Shirey Editor's Note: This article is excerpted from chapter 7 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. In OPM, subroutines are a handy way ...
- Created on 03 July 2023
- 719. Open Source Starter Guide for IBM i Developers: Language Basics
- (Web Languages)
- ... derailed or stumped. Sometimes, Grasshopper, all you need is a little enlightenment! Variables Unlike RPG and more like JavaScript (if you are familiar with it), Ruby is a dynamically typed language. ...
- Created on 30 May 2023
- 720. Open Source Starter Guide for IBM i Developers: Ruby and IBM i, An Introduction
- (Web Languages)
- The goal of this series of excerpts on Ruby and IBM i is to first ground you in the Ruby language. That won’t be easy because Ruby is probably about as different from RPG as an apple is from an orange. ...
- Created on 11 May 2023
- 721. Practical SQL: Change Management with SQL
- (SQL)
- ... joining that list to the BOUND_MODULE_VIEW. The nuance is that I only select those modules where the module name matches the program name. That’s the default configuration of a program created using CRTBNDRPG ...
- Created on 01 May 2023
- 722. Open Source Starter Guide for IBM i Developers: i Object!
- (Web Languages)
- ... in SmallTalk was an object. Everything! I immediately wrote a couple of RPG programs just to restore my sanity. But the light bulb had turned on, and although I could have turned to LISP (the granddaddy ...
- Created on 13 April 2023
- 723. Introduction to /Free I/O Statements
- (RPG)
- ... 6 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. But what about files? So far, we have not really talked about them. How cruelly unfair, as files are at the heart of everything we do. But ...
- Created on 28 February 2023
- 724. Fueling Digital Transformation with IBM Power
- (Industry News)
- ... offering to help streamline ERP. When building applications on IBM i with Merlin, developers can access automated conversion of fixed-format to free-format RPG, built-in security protocols, and modern ...
- Created on 17 February 2023
- 725. Fresche Solutions Acquires Silveredge Consulting to Expand Application Support Services and ERP Capabilities
- (Mergers / Acquisitions)
- ... supports customers running all variations of RPG and other languages, and provide development and ongoing maintenance and modernization for leading ERPs such as Infor (PRMS, BPCS, MAPICS, XA and LX), JD ...
- Created on 08 February 2023
- 726. Can Security and Artificial Intelligence (AI) Mix?
- (IBM i (OS/400, i5/OS))
- ... how you can use ChatGPT to write RPG code. I decided it was time I check it out for myself. Not being familiar with how to use ChatGPT, I watched a YouTube video to get started. Then I had to decide how ...
- Created on 31 January 2023
- 727. Program Flow Using Free Format, Part 1
- (RPG)
- In nearly every program you write, you need to control the flow of instructions. Free-format RPG IV offers experienced RPG programmers a new style for controlling program flow. In this chapter, we look ...
- Created on 25 November 2022
- 728. SQL 101: DML Recap—Joining Tables, Part 2
- (SQL)
- Once you get the hang of this, you’ll be joining tables left and right (pun intended). By Rafael Victória-Pereira We’ve discussed the INNER JOIN, which is similar to the IMPLICIT JOIN you’re probably ...
- Created on 01 November 2022
- 729. Input/Output Using Free Format, Part 2
- (RPG)
- ... is excerpted from chapter 5 of Free-Format RPG IV: Third Edition, by Jim Martin. Workstation I/O To perform workstation input and output in free format, you use the same methods as in fixed format. ...
- Created on 24 October 2022
- 730. TechTip: Printing from a CL Program (the PRTLN Command)
- (CL)
- ... CL language wasn’t designed to create reports—report writing is a strength of RPG. You can, of course, create Query/400 or QMQRY objects and then call them from a CL program to produce a report, but then ...
- Created on 03 October 2022
- 731. Input/Output Using Free Format, Part 1
- (RPG)
- Most input and output functions are the same in free-format RPG IV as in fixed format, except for the location of the code within the source line By Jim Martin Editor's Note: This article is excerpted ...
- Created on 03 October 2022
- 732. The Reasons Why Legacy IBM i Applications Hinder Your Workforce Potential
- (Programming News)
- ... have a terrible reputation for adaptability, and RPG developers' talent gap does not improve things. Unfortunately, users relying on legacy applications to do their jobs may find themselves in antiquated ...
- Created on 19 September 2022
- 733. SQL 101: DML Recap—Joining Tables, Part 1
- (SQL)
- ... the short “RPG-standard” cryptic names that currently exist. Then you’ll see that making a habit of using aliases for the tables and using them when referring to columns in your statements is of paramount ...
- Created on 06 September 2022
- 734. /Free Control Statements, Part 2
- (RPG)
- ... RPG: /Free, ILE, and MVC, by David Shirey. Fortunately, most of what we said for IFs is true for DO loops. The DO itself has been eliminated from /Free (use FOR). And the DOWGT, DOULT, and others of ...
- Created on 06 September 2022
- 735. /Free Control Statements, Part 1
- (RPG)
- ... By David Shirey Editor's Note: This article is excerpted from chapter 5 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. There are no C-specs in /Free. /Free code has logic statements, ...
- Created on 01 August 2022
- 736. Remain Software Releases TD/OMS V14.1, MiWorkplace V1.30 and OCTO 1.0
- (Industry News)
- ... and files has become a matter of seconds. Rest Generator: The RPG Free REST Generator is completely rewritten with Mustache technology. In addition, new functions have been added to the generator like ...
- Created on 14 July 2022
- 737. TechTip: Date Arithmetic in CL Programs
- (CL)
- Date arithmetic in CL programs is limited and lacks the simplicity and scope found in RPG. This article provides a command that brings RPG date capabilities to CL programs. By Sam Lennon Date handling ...
- Created on 25 May 2022
- 738. SQL 101: Introducing the UMADB Database, Part 2
- (SQL)
- ... level, buried in some RPG program. Just a Few Tables, and So Many Problems From what you’ve read so far, you probably concluded this (exaggerated) scenario has some similarities with real-life issues ...
- Created on 28 April 2022
- 739. Practical SQL: Accessing Journals with SQL
- (SQL)
- ... I plan to provide the framework for an even more powerful utility that will do all of this in a single SQLRPGLE program, but until then, please enjoy this concept; I hope it helps even a fraction as much ...
- Created on 05 April 2022
- 740. ILE Activation Groups, Part 3
- (RPG)
- In Part 1 we looked at activation group basics. In Part 2 at types. By David Shirey Editor's Note: This article is excerpted from chapter 17 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. ...
- Created on 05 April 2022
- 741. SQL 101: Introducing the UMADB Database, Part 1
- (SQL)
- ... its current state, it kind of does, but there’s some room for improvement. The UMA application, an “old-style” RPG application, should keep track of the students’ academic lives: the classes they attended, ...
- Created on 28 February 2022
- 742. ILE Activation Groups, Part 2
- (RPG)
- In Part 1 we looked at activation group basics. Now let's take a look at types. By David Shirey Editor's Note: This article is excerpted from chapter 17 of 21st Century RPG: /Free, ILE, and MVC, by ...
- Created on 28 February 2022
- 743. Remain Software Announces 2nd Update to Its Suite of Products
- (Programming News)
- ... editor has been upgraded with a much better and more efficient one. The Studio's RPG generator gives more control to the users, allowing them to influence how the code is generated, thanks to the use of ...
- Created on 22 February 2022
- 744. 2022 IBM i Marketplace Survey Results
- (Operating Systems)
- ... on IBM i continues, and RPG usage soars. The amount of development that takes place on IBM i is always a particular area of interest in our research and this year RPG usage has soared to 93%. We are ...
- Created on 07 February 2022
- 745. Practical SQL: Matching Records with UNION
- (SQL)
- ... ways to get around in SQL using partitions, but it requires some syntax that I don’t find particularly easy to write (or read!). Instead, I prefer to write an RPG program to process the records because ...
- Created on 31 January 2022
- 746. ILE Activation Groups, Part 1
- (RPG)
- ... This article is excerpted from chapter 17 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. The activation group is nothing more than a sub-environment in which an application runs. It defines ...
- Created on 31 January 2022
- 747. SQL 101: Time to Sum Up (and You’ll Want to Bookmark This Article)
- (SQL)
- ... corresponding to the topics mentioned. By Rafael Victoria Pereira The database is so integrated into IBM i that you can program for years without having to explicitly use SQL. RPG provides native operation ...
- Created on 04 January 2022
- 748. How Low Code Helps Businesses Modernize their IBM i Apps
- (Development Tools)
- ... way to the number one spot. It’s no secret that RPG developers are retiring faster than they are being created, and it’s an issue that is projected to widen over the next few years. To make matters ...
- Created on 29 November 2021
- 749. Practical SQL: Complex Summarization
- (SQL)
- ... condition, the program model. The easiest way to determine the program model for a program is to see whether the object attribute has LE in it: that is, such as RPGLE or CLLE. But just take a look at what ...
- Created on 01 November 2021
- 750. ILE Binding Language, Part 2
- (RPG)
- What Binding Language Doesn’t Do By David Shirey Editor's Note: This article is excerpted from chapter 20 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. Please see the previous articles ...
- Created on 01 November 2021