Article Summary: This article is about tackling a fun SQL challenge. The goal was to parse a spool file in a different way than usual, so I could show how to display the data in a table and automate the process. I also wanted to demonstrate how to handle repeating

Scenario: Let’s take a simple query like select * from qsys2.SYSTEM_STATUS_INFO It gives quite useful information, right?  In fact, 109 columns of information that I have to scroll through all right through the screen. And so forth.   Now, what if I want to track these metrics, say