×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
As an Amazon Associate we earn from qualifying purchases.