IBM i, AS400, iSeries, Programming, RPG

Toby’s RPG Snippet to Scan Replace is mental but sexy

wantI was recently copied on an interoffice email from a fellow RPG chappie (he’s quite sharp actually despite his funny mockney accent).

Aforementioned Mockney-Coder was modifying a recent program, written by a legacy RPG3 programmer (these creatures are very rare to find in the wild and we have placed them on the endangered species list).

Amazingly, there are still a handful of RPG Programmers out there who still write in RPG3. RPG3 was upgraded to RPG400 in 1993(?) so if they havent upgraded to RPG400 yet then the chances of getting up to RPGLE and then to RPG/FREE are slim to none.

But Mockney-Coder is a diligent chap and he mentioned a neat little alternative piece of RPG/FREE code that could be used to replace the large subroutines and array handling code chunks needed to perform the same thing in the old fashioned and clunky column based RPG varieties. After all, Variety is the spice of life…

all names have been removed to protect the innocent 😉

...
 Read More

IBM i

Serve JSON Web Services with RPG and YAJL – iProDeveloper

Serve JSON Web Services with RPG and YAJL aka — Access data running on other computers with REST and JSON This is a ressurection of an old article which was lost from the internet when iPro Developer died. Luckily I found an old PDF printout and dutifully copy/pastedf all the text. Thanks to Scott Klement …

 Read More

IBM i, SQL

How to Download IBM i SQL Results As CSV

How to Download IBM i SQL Results As CSV I had to run a rather interesting SQL statement to download journal information: What does this do? Essentially, this SQL snippet retrieves journal entry information for the given journal and the file that is journaled. Running this in the IBM i ACS SQL script explorer gives …

 Read More

Website, Wordpress

Change how Gutenberg looks

Change how Gutenberg looks when editing a page 1 – I like the WordPress Gutenberg Editor OK… OK…. I know there are two camps of people in the WordPress content editing world. There are those that like the new layout of the GUTENBERG editor with its block functions and, those that prefer the old tried …

 Read More

IBM i, AS400, iSeries, Programming, RPG, SQL

Getting a count with SQLRPGLE Variable File Name

Count with SQLRPGLE Variable File Name Been having fun with SQL and RPG ILE this afternoon… the question was “How do I find out if and how many policies exist in one of the reservation files for a given customer code?” Obviously, we could write a little piece of RPGLE doing a READ LOOP and …

 Read More

AS400, IBM i, iSeries, Modernization

Pattern Recognition: Ease Modern RPG Programming

Pattern Recognition: Ease Modern RPG Programming This morning I was reviewing the IBM i Redbook on application modernization, converting this massive PDF into an easy readable TOPIC based format in my AS400 and iSeries modernization course. I found a couple of problems with the internet. Yep, the internet is broken. The ebook has a couple …

 Read More

Programming, Website, Wordpress

How to Change WooCommerce Variable Products “Select Options” to “Add to cart”

UPDATED – Since I wrote this original blog with the (slightly complex) PHP instructions on how to set ADD TO CART, a new WordPress Plugin was released to do this at the click of a button. Check out the bottom of this page in the section titled “The Easy Way – WordPress Plugin WooCommerce Customizer” …

 Read More

IBM i, AS400, iSeries, Modernization, Programming, RPG

Example of an IBM i RPG Single Page Subfile

What are single page subfiles? A single page subfile is a SCREEN OF DISPLAYED DATA, loaded one page at a time. The displayed data is equal to the maximum number of records that can be displayed at a time. In other words, in a single page subfile, all loaded records are displayed at a time. …

 Read More

IBM i, Modernization, Programming

RPG Old and New – Free Form Logic Example

Free Form RPG ILE Logic Example I was recording a screencast about modernizing some old RPG400 to ILE RPG this morning and had to knock up this little code example showing the difference between legacy RPG400 code and modern RPG ILE code. Note, this is not an example of good code (it’s crappy old RPG …

 Read More

IBM i, Programming, RPG, SQL

Example RPG Email Validation program – SQLRPGLE ILE

Let’s look at a quick little example RPG email validation program – SQLRPGLE ILE There are lots of code snippets, example programs, and long waffling discussions in internet land filled with pointy-headed AS400, Series, and IBM i programmer chaps (and chappettes) arguing about the best way to “validate an email address in RPG”. I know …

 Read More

IBM i, Programming, RPG

Using RPGLE to extract invoice numbers from an alpha string

This morning my nerdish IBM-i Chum Toby, pinged me a whatsapp challenge to write a little RPG code snippet to “extract invoice numbers” from a random string of data. So…. if you had a string ‘INV#10563592 DATED 12/17/19 SO#286045 NOT GOING’ and you knew that this is a shitty text file way of referencing an …

 Read More