Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. I was surprised to see there were hundreds of files in this folder and he wanted to list them, and assign different files to different people. “What’s the best way to …
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 …
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 …
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 …
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 …
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 …
