Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
STRSQL is not the only way to use SQL! SQL is a story in two parts — (1) IBM SQL is an interface to the data and (2) runtime SQL is part of the base operating system. IBM I Administrators often want to limit what SQL statements a user is allowed to run because how …
What is this Orion Editor RPG thing? A browser based IBM i code editor which is Open Source, Powerful and just plain saucy. Is the ORION Editor really a free RPG Editor? In the details of the IBM i 7.3 announcement you will find that the Orion editor will be shipped for free as part of …
Pschoville is very reminiscent of A League of Gentlemen – not the movie, but its dark and twisted telly cousin. I love it. Psychoville is weird, humorous, silly, serious and still scary but funny and sometimes disturbing…. confused enough? I sure was. The Clown is pure genius. The Silent Dancer is somehow super scarey. The …
JSON vs XML vs CSV These acronyms can sound like an alien language to people learning to become programmers and especially to established old-school green screen programmers (with the greatest respect to my AS400 and iSeries colleagues) Don’t worry – all these new terms can be totally baffling! Let’s break them down into simple explanations: …
Yesterday, I wrote a little SQLRPGLE web-service program to retrieve System21 Picking details . Days like this I really enjoy my job. Writing new programs in RPG is fun, good old fashioned fun. It ran perfectly with the handful of test data that I had to play with. But today I am testing it and …
IBM i, AS400, iSeries, Programming, RPG
In the 1980’s and 1990’S the source code editor was a text based green screen tool (PDM/SEU) which is still in use at AHP today. This text-based editor does not syntax check any of the new programming languages nor does it allow more than 20 lines of source code to be displayed at any time. …
What is Legacy Code? I’ve always thought LEGACY it was the correct terminology for old fashioned RPG source code. For years I’ve been focused on refactoring old column based RPG “legacy” code into new “modern” RPGLE code. But it seems that I’ve been guilty of using the wrong words all this time. I just read …
Ever wanted to validate or syntax check JSON from within RDi? It’s easy using the free JSON editor from the Eclipse marketplace. This JSON Plugin for RDI will validate, syntax check and polish your JSON layouts with ease. To start you have to go into RDI and get into Eclipse’s Market Place. That will bring up …
During a meeting this morning, I was asked to provide a list of all Customer phone numbers for any System21 Customers that have ever been used on a Sales Order. Perhaps this sounds like a complicated request but… have no fear SQL is here!!! In reality, its a very simple thing to find and takes …
How to Check If an IBM i Command Is Used on Your System: Spotlight on PRTCMDUSG If you’ve been working with IBM i (formerly known as AS/400 or iSeries) for any length of time, you know the system is packed with commands thousands of them, from built-in ones like CPYF (Copy File), WRKACTJOB (Work with …
Turnover User Profiles So, we have IBM i User profiles defined and these users now want to use TURNOVER – so what next? Luckily, defining a user is very simple just launch Turnover (in this blog I use the Windows version running on Windows10) and click the machine you want to administer. TURNOVER FOR WINDOWS …
Want to disable RPGLE Live Parsing? “IBM Rdi” is arguably the best code editor for coding on IBM i. That’s pretty much a given. But, it’s still filled with little annoyances and things that make me groan. One, in particular, is the lagginess and freezing that comes when trying to edit very large programs using …
