Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
Ever had to populate the *LDA in correct layout for JBA ERP Modules (aka GEAC aka Infor System21? Here is a quick and easy JBA System21 *LDA – RPG Example written in RPGLE **FREE format. Here is a simple RPGLE program to setup the *LDA priot to running a few little INFOR SYSTEM21 extraction routines: WEBSETLDA …
What is a single page subfile? A single page subfile is a SCREEN OF DISPLAYED DATA, loaded one page at a time. The displayed data is the number of records that are loaded and displayed at a time. In other words, in a single page subfile, all loaded records are displayed at a time. We …
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 …
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: …
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 …
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 …
IFS profile disabled? So, I have a love/hate relationship with IBM i’s integrated File System (IFS) Does you keep getting asked for username and password when accessing a windows IFS share? Are you confused why the share to your IBM I Server cannot be viewed in Windows Explorer? Can you view the IFS from one …
So, just when I thought I had seen it all, I got this error message “Unable to move file into a new library” when I was just moving a file to a new library in my lovely IBM i System. Nothing weird about this file (or so I thought) and I was just going a …
RUNSQLSTM – Run SQL Statement When you do the RUNSQLSTM to create your SQL Objects – Do not qualify library names but use the Turnover variables just like you would define PDM variables: Turnover uses the DFTRDBCOL column “&LI” to populate the other *library* variables. Most shops I’ve been to use QSQLSRC to store the …
IBM i, AS400, iSeries, Life, Programming
UPDATE JULY 2020 – IBM CHANGED THE RULES AND NO LONGER OFFER THIS SERVICE TO ALL DEVELOPERS 🙁 Since I wrote this blog way back in 2016, IBM have changed their minds and now only offer the “TRY an IBM i ” service to Business partners. But fear not — If the phrase “Free IBM …
“How do I check the status of the System 21 (JBA/GEAC/INFOR) background jobs from an RPG program?“ I was asked to hack together a quick little routine to check the status of the System21 background jobs, for some specific web-service calls that were talking to an IBM i system running INFOR’s System21 ERP. Hmmm… That …
