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

Read More

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

Read More

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

Read More

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.

Read More

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

Read More

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

Read More

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

Read More

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

Read More

From AS400 to IBM POWER SYSTEM The IBM AS/400 was one of the most robust operating systems of the late 20th century. Fast forward to 2023 and the grandson of the AS/400 is the IBM Power System. This new generation of IBM BUSINESS SERVER is running the IBM i Operating System. IBM i is fully

Read More

Do you want to Create Different Subsystems for Web Services? There are a lot of positive reasons for us to create separate subsystems for each out our sets of applications. But if you read this blog entry then you already know that. So, assuming you want to do it — let’s stop blathering and dive

Read More

IBM i Subsystems IBM i Subsystems are used to control jobs and functions. A subsystem description defines how, where, and how much work enters a subsystem, and which resources the subsystem uses to do the work. IBM i is shipped with a standard set of subsystems The following subsystems are necessary for supporting user work: Interactive

Read More

Special Authorities – What are they on IBM i? If you come from the world of IBM I you will have heard of *ALLOBJ authority. This is the ultimate level of object access authority on an IBM I system. *ALLOBJ literally means you are authorized to read, change, or delete any/all objects on the system!

Read More