Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
RUNSQLSTM to create the table. Not qualified, so make sure you specify DFTRDBCOL. Must have this library in library list to create DMPJOBSCD1.RPGLE.
No hardcoded library names, so make sure it's all in your library list (I keep it in a single library), then just CALL DMPJOBSCD. Results are in table JOBSCDE. Contents of table are directly from List entries for List Job Schedule Entries (QWCLSCDE) API.
RUNSQLSTM to create the table. Not qualified, so make sure you specify DFTRDBCOL. Must have this library in library list to create DMPJOBSCD1.RPGLE.
No hardcoded library names, so make sure it's all in your library list (I keep it in a single library), then just CALL DMPJOBSCD. Results are in table JOBSCDE. Contents of table are directly from List entries for List Job Schedule Entries (QWCLSCDE) API.