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.
I looked on the web for ways to extract the JOBD LIBL into a file for analysis, and found a few, but the links are now broken. Any one out here know of a place to see examples of how to do it?
Joel,
Does it have to be into a file? You can retrieve the libl with the RTVJOBA command and parse out the individual libraries.
Just an idea. Good luck.
Chris
Use QWDRJOBD (google it and look for the publib.boulder.ibm.com url's).
To extract library list you need to extract the entire length of data available
360 | 168 | BINARY(4) | Offset to initial library list |
364 | 16C | BINARY(4) | Number of libraries in initial library list |
* | * | ARRAY (*) of CHAR(11) | Initial library list |
File is best as it will end up in excel for analysis of the many, many jobds.
I did finally find an example on the web (might be one of cozzi's).
I have downloaded the source and will see what I get out of it!
Sorry full solution would be: