Re: SQL - Generate Spreadsheet

Bryan:

Your example:

VALUES
Systools.Generate_Spreadsheet(
Path_Name => '/tmp/query_spreadsheet',
SPREADSHEET_TYPE => 'xls',
Spreadsheet_Query => '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', Column_Headings => 'COLUMN’);

Worked perfectly. Thanks to you and Simon for the examples….

Now on to the easy part of the project!
--
Jim Oberholtzer
Agile Technology Architects