Viewing the job's overrides

SQL View OVERRIDE_INFO gives a list of all the file overrides for the current job

Update to the technical resources roadmap

This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of

Using SQL to view system problems

Work with your system’s problems using the PROBLEM_INFO SQL View

Wisconsinites join the RPGPGM.COM-unity

New members of the RPGPGM.COM-unity who joined at WMCPA iCon 2026

Reducing the amount of unnecessary Index Advisor data

Automatically purging the Index Advisor using a Global variable for the time to retain the data

Limiting the amount of data SELF retains

New SQL global variable introduced to help limit the amount of data kept in the SELF error log table

Attend NEUGC | NEUGC

Finding Table functions with SYSFUNCS

SQL View SYSFUNCS allows me to list all the information about Scalar, Column, and Table functions all from one place

Retrieving the description for the Audit Journal Entry Types

SQL View JOURNAL_CODE_INFO allows me to get a list of all the Audit Journal Entry Types and Journal Codes with just a simple SQL statement