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

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

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.

...
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