RE: JOBD analysis

Agreed, the API is the better solution, especially for long term and flexible use.
However, dspjobd jobd(x) outfile(*print) does, here in mudville, include the lib list.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, May 08, 2013 9:10 AM
To: Midrange Systems Technical Discussion
Subject: RE: JOBD analysis

Paul and Gary,

Neither displays library list. Unless Gary meant DMPOBJ when he said to dump the object. Yeah, I'll think I'll stick with API's versus deciphering that crap.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Paul Nelson" <nelsonp@xxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>,
Date: 05/08/2013 11:01 AM
Subject: RE: JOBD analysis
Sent by: midrange-l-bounces@xxxxxxxxxxxx



DSPOBJD will permit you to do that

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Wednesday, May 08, 2013 9:59 AM
To: Midrange Systems Technical Discussion
Subject: RE: JOBD analysis

Yes - that is my question. How to do step 1: "dump all job descriptions
to
a work file" ??


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Wednesday, May 08, 2013 9:47 AM
To: Midrange Systems Technical Discussion
Subject: RE: JOBD analysis

Joel,
1) dump all job descriptions to a work file
2) create table normaljd as (
select distinct jobd from workjobd )
with data
to get last-used date you will need to add detail to the above,
but this should help get you going

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Wednesday, May 08, 2013 8:42 AM
To: 'Midrange Systems Technical Discussion'
Subject: JOBD analysis

I would like to dump all job descriptions to an *OUTFILE with their
library
list as a "normalized" file, ie one record for each lib in the *libl of
the
JOBD.

Also include last-used date of the JOBD.

The goal is to find out which JOBD's reference certain TEST libraries.

Any ideas how to accomplish?

Thanks



______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.