IBM i, AS400, IFS, iSeries, Programming

Search Scan Replace text in IFS files on IBM i using QSH – iSeries AS400

Search Scan Replace text in IFS files on IBM i using QSH This morning I wanted to find a quick and dirty way to “Scan Replace text in IFS” files without writing a program to do it…. SPOILER ALERT – it’s really really insanely simple using JAVA QSHELL and the SED command So, before I …

 Read More

IBM i, AS400, IFS, Programming, RPG, SQL

Scan Replace in RPGLE and SQLRPGLE

Want to Scan Replace in RPG? In the middle of this RPG program, I want to reformat and replace some values in a big long address field. But for the life of me… I can’t remember how to use the SCANREPLACE built in function in RPG. #Dingbat /me memory circuits need a service methinks. So, like …

 Read More

IBM i, Programming, RPG

using %REPLACE to Scan Replace in RPG

UPDATE 2017 : USE %SCANRPL Built in Function – IBM added a %BIF to do this for us in modern RPGLE so we can now just do a %SCANRPL in native RPG. I’m leaving this old blog here for reference but look HERE for the modern and much easier way of doing this schnizzle So, You …

 Read More

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