...
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 …
This is an excerpt from INSIDE THE AS400 – a must read for any System i, AS400 or iSeries techie… It’s in the Sauce “It’s in there; it’s all in there!” exclaims the TV commercial for a well-known brand of spaghetti sauce. Instead of buying the ingredients and making your own sauce, argues the …
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.
...Loving the new Beta release of LIVE MESSENGER and the LIVE EMAIL Client.
I’ve been a big fan of Microsoft Messenger since the 90’s and my early experiences of Yahoo messenger, ICQ (whatever happened to that?) and Trillian. More recently I exclusively use SKYPE for my VOIP and occasional chatter to clients and/or other skype community members, but still prefer messenger for keeping in to contact with friends and family.
It’s latest incarnation (Live Messenger) is the best yet and this Beta makes things even cuter.
...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 …
So, we all know that downloading big, fat files from the internet can be a big, fat pain in the big, fat arse. Luckily a free tool called “Free Download Manager” takes that pain away. Even if you enjoy a fast internet connection, being disconnected near the end of a big download can make you …
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 …
What is a load all subfile? A load all subfile is one in which we generally specify the subfile size as 9999 in the record format itself. However, you may define the subfile size to be less than 9999 in the record format and still load all your subfile at a time. In that situation …
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 …
A copybook is a technique that us RPG PROGRAMMERS use to suck in piece of re-useable code without having to type it every time into lots of programs. A typical use of a copybook might be something like this scenario: Every program within an application uses the *LDA (Local Data Area) to store specific pieces …