IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Generating report with DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Wed Apr 17, 2013 8:36 am
Reply with quote

Hi,

I have a requirement where in I need to find the list of all predecessors of a job. Could some one guide me in this if this can be done using DFSORT.

I have two seperate files

File 1 - FB 80 (List of jobs for which the predecessort list needs to be identified.

Code:
Jobname1
Jobname2

File 2 - FB 80

Original Job - Pred Job (Immediate)
Code:
Jobname1|Jobname2
Jobname1|Jobname3
Jobname2|Jobname4
Jobname2|Dummyjob
Jobname3|finaljob

My output should be

Code:
Jobname1|Jobname2|Level 1
Jobname1|Jobname3|Level 1
Jobname1|Jobname4|Level 2
Jobname1|Dummyjob|Level 2
Jobname1|finaljob|Level 2
Jobname2|Jobname4|Level 1
Jobname2|Dummyjob|Level 1


In my site, we are using OPC scheduler, in which there are options to view the above output information for a particular job operation in online, but I need them in an output file format for analysis which couldn't be generated. There are option only for reporting the immediate predecessor list for the jobs but not beyond that.

Thanks
Bharath
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Wed Apr 17, 2013 12:29 pm
Reply with quote

OPc will tell you that with one of its basic reports.
Back to top
View user's profile Send private message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Wed Apr 17, 2013 12:34 pm
Reply with quote

Hi Nic,

OPC gives only a report "Internal and External Dependancies' which gives the immediate pred and successor details as denoted in File 2 of my requirement ( I produced the File 2 using Rexx on top of the OPC report) and not to the levels after that.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Apr 17, 2013 12:57 pm
Reply with quote

Original Job - Pred Job (Immediate)
Code:
Code:

Jobname1|Jobname2
Jobname1|Jobname3
Jobname2|Jobname4
Jobname2|Dummyjob
Jobname3|finaljob


Jobname2, Jobname3 etc. are NOT pred jobs but successor jobs.

And how about external dependencies?
Back to top
View user's profile Send private message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Thu Apr 18, 2013 5:46 am
Reply with quote

Hi Peter,

I would explain my file 2 in the requirement in detail again for better understanding.

My File 2 contains the predecessort job of all the jobs in column 2 (after the seperator '|')

Job 1 has a predecessor of Job 2 and 3
Job 2 has a predecessor of Job 4 and Dummyjob
Job 3 has a predecessor of finaljob

If I want the complete list of predecessors of Job 1, then the output would be

Job1 - Job2
Job1 - Job3

The above records are level 1 because they are immediate.

Also Job 1 has the following level 2 predecessors because of Job2 and Job3

Job1 - Job4 (Pred of Job2)
Job1 - dummyjob (Pred of Job2)
Job1 - final job (Pred of Job3)

Say suppose, in case there is a predecessor for Job 4 in file 2 as Job5, then it will be a Level 3 pred of Job1. So, my output file should contain the following line as well

Job1|Job5|Level 3

While I generate the report of file 2 for all the immediate predecessors of the jobs in my schedule, I have taken care of both Internal and external predecessor as well.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Thu Apr 18, 2013 12:19 pm
Reply with quote

This is what you say :


Code:

job 2      job 3
    |          |
    -------------
           |
        job 1
Back to top
View user's profile Send private message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Thu Apr 18, 2013 12:30 pm
Reply with quote

Yes Peter. You got it right!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts Need help on formatting a report DFSORT/ICETOOL 14
Search our Forums:

Back to Top