Re: SQL - Generate Spreadsheet

thinking about other ways to create the xls....
If you have the IBM i on fairly recent PTFs the acsbundle.jar exists in the IFS.

so you could run the following from qsh

java -jar /QIBM/ProdData/Access/ACS/Base/acsbundle.jar
/system=localhost
/PLUGIN=cldownload
/sql="SELECT SYS_DNAME AS LIBRARY,SYS_ONAME AS OBJECT,
OBJTYPE,USER_NAME,OBJ_AUTH,
OBJOPER AS OPR,OBJMGT AS MGT,OBJEXIST AS EXIST,
OBJALTER AS ALTER,OBJREF AS REF,
DATA_READ AS READ,DATA_ADD AS ADD,DATA_UPD AS UPDATE,
DATA_DEL AS DELETE,DATA_EXEC AS EXECUTE
FROM QSYS2.OBJECT_PRIVILEGES
WHERE SYS_DNAME = 'QSYS'
AND OBJTYPE = '*CMD'
ORDER BY SYS_ONAME,USER_NAME"
/clientfile=/tmp/put_your_file_name_here.xls
/colheadings=1

see the GettingStarted.html and look for "9.1.17 CLDownload" section

(tip for extra lines in QSH, type an "18" then press F-14 )



if interested in a CL, I had this bookmarked:
https://www.web400.com/downloads/ACS/xfrdta.clp.txt

Bryan




Jim Oberholtzer wrote on 7/2/2025 2:37 PM:

What I need to do is generate the spreadsheets, I don’t need to consume the file in CL. The CL would only be a wrapper to run all the SQL statements needed. The preferred output would be a spreadsheet in the IFS.

So I’m still not clear on how to build the SQL so it will at least run in ACS.