06
Mon, Jan
2 New Articles
  1. You are here:  
  2. Home
  3. Search

Total: 3549 results found.

Search for:
Search Only:

Page 15 of 71

701. Kisco Awards two Fellowships and Announces Program Expansion
(Career)
... University and additional technical college coursework under his belt, Blake discovered IBM i though his help desk role at his sponsoring employer, Dixie Group. He looks forward to learning about RPG and ...
Created on 29 July 2024
702. Practical Middleware: Architecting for the Future
(IT Infrastructure - Other)
... by using some combination of Linux, Tomcat, IBM i (RPG and DB2), and Node.js. That’s my version of the ubiquitous LAMP stack: Linux, Apache, MySQL, and PHP (or Python or Perl). So what does my infrastructure ...
Created on 01 July 2024
703. SQL 101: DDL Recap—Improving Our Basic SQL Tables, Part 1
(SQL)
Now that we have basic SQL tables that are still RPG-friendly, let’s start to make them more recognizable (and usable) for non-RPG developers by adding some typical SQL features, like keys, default values ...
Created on 04 June 2024
704. The Importance of BIFs, Other Conversion BIFs
(RPG)
... you can use. Part One here. By David Shirey Editor's Note: This article is excerpted from chapter 12 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. %EDITC (Edit with Edit Code) This ...
Created on 03 June 2024
705. The Importance of BIFs, BIF Essentials
(RPG)
BIFs are not technically part of /Free. You can use them in RPG IV positional. But they are so much more necessary in /Free that it only makes sense for us to look at some of the most common ones and see ...
Created on 25 April 2024
706. Selection Process Open for Kisco’s IBM i Career Development Fellowship
(Career)
... to launch careers by helping them develop IBM i skills in house. Applicants for the fellowship must be sponsored by an active IBM i customer and will receive: free IBM i and RPG training; a one-year COMMON ...
Created on 09 April 2024
707. Practical Middleware: Starting the Journey
(IT Infrastructure - Other)
... application interfaces. My goal is to show you how to build an ecosystem around your business rules. Nothing beats ILE RPG combined with embedded SQL for developing those rules, but we need to make them ...
Created on 01 April 2024
708. 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
709. 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
710. 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
711. 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
712. 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
713. 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
714. 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
715. 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
716. 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
717. 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
718. 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
719. 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
720. Media Kit - 2025
(General Content)
... three newsletters to unique opt- in subscriber lists on the 1st, 2nd, and 3rd Wednesday of every month. MC Systems Insight, MC RPG Developer and MC TNT Tips ‘n Techniques. . Audience size is approximately ...
Created on 21 September 2023
721. 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
722. 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
723. 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
724. 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
725. 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
726. 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
727. 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
728. 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
729. 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
730. 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
731. 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
732. 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
733. 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
734. 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
735. 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
736. 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
737. 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
738. 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
739. 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
740. 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
741. /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
742. /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
743. 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
744. 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
745. 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
746. 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
747. 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
748. 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
749. 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
750. 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