Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
What is the system part of IBM i Library List? SYS – System The System (SYS) portion is always at the top. This is typically the libraries containing operating system objects. You can add libraries to your JOB’s system portion using the CHGSYSLIBL command – NOTE THIS IS FOR YOUR JOB ONLY PRD – Product …
IBMi Modernization The Challenge of AS400/ISERIES Application Modernization, Database SQL Conversion and Cloud Migration Regardless of where you are in the world and whenever you are reading this blog entry, 99.99% of AS400 and ISERIES applications are running on an IBM i Power System. The reason I saved a .01%, is because I know of …
Count with SQLRPGLE Variable File Name Been having fun with SQL and RPG ILE this afternoon… the question was “How do I find out if and how many policies exist in one of the reservation files for a given customer code?” Obviously, we could write a little piece of RPGLE doing a READ LOOP and …
What is VISUAL STUDIO CODE? Microsoft Visual Studio Code, “a free-editor that helps the programmer write code, helps in debugging and corrects the code using the intelli-sense method”: Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. It comes with …
AS400, IBM i, iSeries, Programming, SQL
How to Substring a Packed numeric in a Logical File So – you have a Physical file and you want to create a logical with substrings of file data or maybe concatenation of the same data. “That’s easy” I can hear you think… but… but… what if you need to do this with a substring …
Every propeller head takes some kind of perverse joy from wiping and reinstalling their Windows Machine. I know I do. After a year of various software installs, un-installs, re-installs, tweaks, hacks, dicking around (that’s a technical term) my Windows machine starts to get twitchy and a little punch drunk. It’s time for a fresh install and …
Infor (JBA) System 21? A recruiter asked me if I had heard of INFOR System21, because he had found an old blog talking about JBA and JBA System21. He wondered if they were similar applications. The Answer is YES: System 21 is an ERP – Enterprise Resource Planning solution. System/21 ERP was originally written by …
The State of AS400 iSeries Application Modernization Historically, our old AS400 and ISERIES applications were stateful. In information technology and computer science, a system is described as stateful if it is designed to remember preceding events or user interactions; the remembered information is called the state of the system. So, if we are looking at …
Pattern Recognition: Ease Modern RPG Programming This morning I was reviewing the IBM i Redbook on application modernization, converting this massive PDF into an easy readable TOPIC based format in my AS400 and iSeries modernization course. I found a couple of problems with the internet. Yep, the internet is broken. The ebook has a couple …
Firewalls – Ports – TCP/IP Three words that strike fear into most IBM i programmers. General Use — Green screen emulator, ftp, file sharing etc. On the IBM i System, most of the host servers can be configured for SSL by using the Digital Certificate Manager (DCM) to assign a certificate to that individual server. …
JBA System 21 – How to recover incomplete Accounts Payable sessions AP incomplete session PL incomplete session AP session recovery Background For most types of Accounts Payables sessions that are incomplete (status ‘I’), the user can cancel or complete the session themselves, as below. The Accounts Payable Processing options that can be recovered in this way are: Item …
The maximum password complexity on IBM i can be quite extensive, especially when using higher password levels. Here are the key points: Which raises the obvious question: How do I go about setting long IBM i passwords to match those in the Windows World? By setting the system to these higher levels, you can significantly …
