Midrange News for the IBM i Community


Posted by: Joel Quisenberry
Anahiem, CA
Extract JOBD LIBL
has no ratings.
Published: 31 Jul 2012
Revised: 23 Jan 2013 - 3785 days ago
Last viewed on: 02 Jun 2023 (5363 views) 

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.

Extract JOBD LIBL Published by: Joel Quisenberry on 31 Jul 2012 view comments(4)

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?

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: chrisp
Premium member *
Portland, OR
Comment on: Extract JOBD LIBL
Posted: 10 years 10 months 5 days 1 hours 51 minutes ago

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

Posted by: neilrh
Premium member *
Jackson, MI
Comment on: Extract JOBD LIBL
Posted: 10 years 10 months 5 days 38 minutes ago

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
Posted by: qberryinc
Premium member *
Anahiem, CA
Comment on: Extract JOBD LIBL
Posted: 10 years 10 months 4 days 23 hours 30 minutes ago

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!

Posted by: neilrh
Premium member *
Jackson, MI
Comment on: Extract JOBD LIBL
Posted: 10 years 10 months 4 days 9 hours 25 minutes ago

Sorry full solution would be:

  1. Create file for library list data.
  2. Create program that lists all jobd's on system into a userspace, then cycle through the entries in the userspace and retrieve the library list and other data of the jobd, an write a record for each into the file.
  3. Run the program.