Guru: Find Unused Objects On IBM i Using SQL

May 15, 2023 Bob Cozzi

I have a client that uses SQL iQuery for nearly all “Report” type applications since SQL iQuery Version 2. They asked if they could create a report that listed all the unused objects in their user libraries. They also wanted the option to output to Excel-compatible format if desired.

Since SQL iQuery allows you to output the results of your SELECT statements to any of its supported formats, Excel-compatible is given.

Note: the code for this article is avaialble on GitHub at this link.

There were a couple of approaches. I could use our other product, SQL Tools OBJECT_LIST …