Given a list of objects, run SQL Queries on it

It’s audit season, and auditors being auditors want quite a bit of almost useless information from a long list of objects, IE: DSPOBJAUT on command STRDFU. A) it’s already locked out from all users (where it even exists) except a very small list of *ALLOBJ users, B) I removed it from the production systems. But the auditors still want to see a null data set.

So, what I would like to build is an SQL based procedure that will run all the various reports they want. The reports would be separate Excel spreadsheets for each object.

Read list of objects
Run a series of SQL commands to get data (IE DSPOBJAUT, sql version not the command)
Create the spreadsheet
Loop back to the list until EOF.

My limited SQL abilities stop me from doing this in SQL. I could do it in CLLE but the auditors would reject it since they cannot spell IBM i without being spotted the “I”. The can read SQL.

Suggestions?


--
Jim Oberholtzer
Agile Technology Architects