From AS/400 to iSeries to System i to IBM i on Power
Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
It’s time to move MOVE out of old RPG Programs One of the biggest mistakes I’ve made while trying to modernise old RPG code, is simply importing the old code and trying to take the whole thing as one lump upgrade to modern RPG ILE. Hindsight is 2020, and something I’ve learned from the many …
IBM i HTTP Web Server Authentication using an IBM i User Profile and Password We tend to think of consuming a webservice (“connecting and reading from a webservice”) as something that is open to the public. But what if we want to add an extra level of authentication? How about we force the connection to …
Serve JSON Web Services with RPG and YAJL aka — Access data running on other computers with REST and JSON This is a ressurection of an old article which was lost from the internet when iPro Developer died. Luckily I found an old PDF printout and dutifully copy/pastedf all the text. Thanks to Scott Klement …
RPG Subprocedure Tips and Techniques The use of subprocedures in your applications should be on everyone’s “to do” list this year. You don’t need to drop everything and rewrite your applications to take advantage of subprocedures and many other benefits that the Integrated Language Environment (ILE) offers. However, when writing new applications or performing major …
If I don’t like poetry. I especially don’t like it when people call it ‘Poyetrey‘ in that weird pronunciation way… but… this poem, just blows me away: IF – Rudyard Kipling If you can keep your head when all about you Are losing theirs and blaming it on you, If you can trust yourself when …
Comparing Object Authorities across different libraries is easier than you think! Using the magical powers of IBM i SQL we can easily create a spreadsheet containing all the objects in any given library and showing all their authority settings. You can run this SQL statement using green screen STRSQL or from your favorite desktop SQL …
Control Command Line Access Here is a brief guide on how to control command line access for IBM i users: IBM i User Limited Capability Feature The Limit Capabilities feature in IBM i allows you to control the ability of a user to run CL commands at a command line by specifying the LMTCPB (Limit …
Restore and Rescope Logical Files When you restore a logical file, the system uses the description for the logical file to establish its relationship with the based-on files. For example, database views or indexes are logical files. You can restore a logical file to a library different than the library for the associated physical file. …
Have you ever seen a ‘Library QTEMP not found’ error? Weird Huh? After some head scratching we figured it out – this IBM i Power System is using an Independent Auxiliary Storage Pool (aka iASP). The previous administrators had installed and configured the iASP, but then decided to change the core IBM i System commands …
A simple guide to SQL for AS400 Dummies You can spot my brethren fairly easily, the rare old-school AS400 developer can be found lumbering around your IT department. The trade mark style of these rare IBM Beasts is graying hair, a low-tech phone, typing with 2 fingers while muttering swear words under their breath. Counting …
Lots of IBM i Deleted Records? Want to find the 100 Files with the most deleted records in them? Ready to purge those Beauties? For years us AS/400, iSeries and IBM i Techies have been using the Display File Description Command to create output files containing record counts for files. The traditional process is something …
There are a multitude of ways to check the IBM i OS version on your IBM i System (No it is NOT an AS400 or iSERIES machine – Don’t argue. Don’t!) You can do it from Control Language Programs You can do it from RPG programs You can do it from SQL You can do …