Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
IBM i, IFS, Programming, SQL
How to delete first few rows from a file with IBM i SQL This morning I was working with a flatfile import from IFS into a DB2 database file. This should have been straight forward but the flat file contained several rows of crappy data at the start of the file. *ugh* Since I am …
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 …
Using CPYFRMIMPF to use flat text files in the IFS The Copy from Import File (CPYFRMIMPF) command can be used to copy data from any IFS file into an IBM i (DB2) Table. It handles very simple delimited file conversions like CSV files and also straight flat text files. The Copy to Import File (CPYTOIMPF) …
Short expressions – simple math expressions (+ = …) : Is A=A+1 the same as A += 1 ? The short answer is YES If you are an old style RPG programmer, evolving into a modern RPG programmer you will frequently see this style of coding when looking at modern RPGLE code examples: $variable += …
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 …
Rules for good coding style I started this with the idea of writing a blog about “Rules for good RPG coding style”, I was discussing this with an old friend and colleague yesterday. He moved away from the AS400 machine, just as it was being replaced with the old iSeries machine. He’s now spent nearly …
It’s a quickfire process for launching incoming ODBC and JDBC connection requests. Things like running an SQL script from your PC will initiate a job called QZDASOINIT to run that request. The QZDASOINIT job on IBM i systems is a prestart job used by the database host server to handle SQL requests from JDBC and ODBC client …
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 …
