...
Looking for Something?
Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
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 …
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.
...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 …
IBM i, AS400, iSeries, Programming, RPG
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 …
IBM i, AS400, iSeries, Programming, RPG
Expandable subfiles in RPGLE An expandable subfile is one in which ideally one page of records are loaded at a time. Subsequent pages are added to the subfile as per the user demand. In the expandable subfile the subfile size must be at least one greater than the page size. The ILE RPG program to …
IBM i, AS400, iSeries, Programming, RPG
What are RPG COPYBOOKS anyway? Copybooks are a very simple way of reproducing the same code into many programs: a copybook is a source member containing a section of code that can be inserted/copied into any other source member at compilation time. The main idea behind RPG Copybooks is re-usability. Think of a copybook as …
When IBM introduced RPG IV (RPGLE) back in the mid 90’s, most of the RPG III opcodes were converted into built in functions. This makes for more readable code and efficient programming. The built in functions each do a particular function just like any opcode would have done. Since the built in functions are provided …
AS400, IBM i, iSeries, Programming, RPG
Conditional selection in RPGLE In RPGLE we have the following conditional opcodes available: The If-EndIf block The If – Else- EndIf block The If – ElseIf – Elseif – EndIf block The Select Block Let’s look at them one by one. The If-EndIf in RPGLE If we want some RPGLE Statement(s) to be executed conditionaly. …
Cryptography isnt the art of keeping dead bodies in a crypt I must admit to being a little baffled by cryptography, data encryption and all that SSL nonsense… so this was very interesting to read: Cryptography and the AS/400 Question: I need some help. I have AS/400 F20 in central site and about 30 terminals and …