Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. “What’s the best way to read all the spreadsheets in an IFS folder so we can process them?” bald bloke in the office Well, we have a nice simple technique to

Read More

IBMi Control Language, Templates and Subroutines Control Language (*CLP) is a wonderful little tool in every IBM i Programmer’s toolkit. Sadly it’s frequently derided, frowned upon and ridiculed by RPG chaps and chappettes. OK, so CL isn’t a full suite business language, but reminds me of learning BBC BASIC back in my school days. I

Read More

Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data I

Read More

Twenty years ago these are the kind of things you had to know to work on the old AS400 systems. I found these on an old dusty corner of my homeserver. Enjoy the trip down memory lane or to use old RPG lingo AS400NERD CABEQ ‘1’  START CONTROL LANGUAGE (CL/400) How to start a CL

Read More

Control Language (CL or CLP) has a neat and little used header specification command called ‘COPYRIGHT’ Just like the RPG header level COPYRIGHT parameter we can also do the same thing in CL programs. By using the COPYRIGHT command in CL we can embed our companies copyright statement into the code for the program. What

Read More

Visual Studio with the Code 4 IBM i Plugin is my preferred RPG code development tool. Unlike IBM Rational Developer which is expensive but one could reluctantly argue that it’s worth the cost to access all the latest and greatest enhancements to the evolving RPG language direct from IBM. I wouldnt argue that 😉 Microsoft

Read More