Any program can easily find out the mode it is running in by calling an IBM supplied *API – which will return the status of the job we are running. Basically, we just have to teach our program to shout “Hey Dude – am I running in batch or what?” and then the dark lord …

Read More

another snippet from an old document I found in a dim dark and hazy corner of an even older HDD… rather than let it disintegrate, here it is migrating to the web just in the (extreme) off chance that it may be useful to someone out there. Hey.. if YOU are reading this then its …

Read More

The process for developing software is really simple, it just needs to be burned into your brain. If you are just starting a career in programming you will hear the acronym “SDLC” thrown around. So here is a quick little primer. The SDLC is also known as Classic Life Cycle Model (or) Linear Sequential Model …

Read More

PSDS – Program Status Data Structure A program status data structure (PSDS) can be defined in an RPG program and it makes program exception/error information available to the RPG program. The PSDS must be defined in the main source section; therefore, there is only one PSDS per module. A data structure is defined as a …

Read More

So, I’ve decided its time for me to step up to the plate (to use a strange Americanism) and get ready to take my collection of IBM i Software Developer Utilities to the next level… *Deep Breath* PROJEX4I is Ready… nearly 😉 I’m at the final part of a major product re-write for PROJEX4I and …

Read More

AS400 is Legend JULY 2019 UPDATE — This is an old Blog. I can’t believe I wrote this over ten years ago. But, I look in the mirror and see this gray racing silver bonce and I realize that it really might have been this long ago. In recent years, RDi has become the RPG CODE …

Read More

What is the IBM i Database?

IBM i has a database which stores data in files. These are called physical files.

The Physical file stores the actual data.

The data is written to a physical file in arrival sequence. This data can be accessed by RRN (relative record number) where the first entry on the file (also known as a table) is relative record number 1. ie: the first record in the file. The next record is RRN=2 then RRN3 and so on.

If you want to access the data using a sequence of something on the file (for example CUSTOMER sequence) then you would design and create a logical view of this physical file specifying that you want it sequenced by customer.

...
Read More

Prompting a list of all customers defined in Sales Ledger (or Account Receivable as its also known) is simple from within any JBA RPG program. A call to SL016 – JBA Customer Inquiry – pops a window up, you select you customer using various subset, selection functions and it will be returned to the calling …

Read More

Here’s one to change a 6,0 numeric date in MMDDYY form to 7,0 numeric date in CYYMMDD form. INTERAL_DATE is the 7,0 CYYMMDD date. EXTERNAL_DATE is the 6,0 MMDDYY date.

...
Read More

The RPG Logic Cycle  The RPG LOGIC CYCLE is the backbone of the old RPG programming language. It’s use has faded in recent years but it should still be known and understood by every modern RPG language Developer 😉 So, regardless of whether you want to code modern or *cough* old style…. Let’s see what …

Read More