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 …Read more