Re: SQL, generate spreadsheet

Jim,
A simple google query, e.g.:
   ibm i SQL GENERATE_SPREADSHEET scalar function 
gives a good explanation with an example, as well as numerous good web pages describing same.
All the best,
Mark S. Waterbury
On Wednesday, July 2, 2025 at 12:08:35 PM EDT, Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx> wrote:

I have this SQL that I stole from Simon Hutchinson, (altered to include what I need)  but the last bit is to generate a spreadsheet from the output.

I see the generate spreadsheet scalar function,  but the documentation is not clear or my SQL stupidity is coming out.  How do I set this up to generate a spreadsheet when run from an CLLE program?

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


--
Jim Oberholtzer
Agile Technology Architects