Output Report Required:
(Included line numbers for reference)
Code:
12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
JOBNAME ,LASTRUN ,JOBTYPE ,AGENT ,USERID ,TRIGGERED JOBS ,REQ JOBS
FOFAC001,18310/0030,UNIX_JOB,LINUX_01ABHK,UMIKE001,BOFAC001;COFAC001;DOFAC001,
FOFAC002,18310/0030, , , , ,BOFAC001;MOFAC001
I tried the below code and was able to group records. I also tried INREC IFTHEN but couldn't get required results. Please help. The 'PROSE' section under each job could be ignored, each job in a particular section is delimited by a ';'.
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
hiravibk,
A couple of questions.
What are the criteria that determine 'TRIGGERED JOBS' vs 'REQ JOBS'?
Quote:
The 'PROSE' section under each job could be ignored
Did not really get what you meant by this, could you explain further? Looks like all the job names that you need in the output are technically below the 'PROSE section'.
What are the criteria that determine 'TRIGGERED JOBS' vs 'REQ JOBS'?
Quote:
The 'PROSE' section under each job could be ignored
Did not really get what you meant by this, could you explain further? Looks like all the job names that you need in the output are technically below the 'PROSE section'.
1. The input file will have details of a job spanning several lines with sections - AGENT INFORMATION, PROSE , TRIGGERED JOBS and REQUIREMENTS AND NETWORK CONNECTIONS.
2. I dont want details under PROSE, but want certain details for the job from all other sections. For eg for the first job FOFAC001, it doesn't have 'REQUIREMENTS AND NETWORK CONNECTIONS' section, so in output file, for FOFAC001 it has blanks under 'REQ JOBS'. But the second job FOFAC002 has this section.
3. In the input file, the headers for each sections (AGENT INFORMATION, PROSE , TRIGGERED JOBS and REQUIREMENTS AND NETWORK CONNECTIONS) begin at the same positions for all the jobs i.e.:
a) 'AGENT INFORMATION' header begins at 35.
b) 'PROSE' header begins at 42.
c) 'TRIGGERED JOBS' header begins at 37.
d) 'REQUIREMENTS AND NETWORK CONNECTIONS' header begins at 25