|
View previous topic :: View next topic
|
| Author |
Message |
hiravibk Warnings : 1 Active User
Joined: 14 Dec 2008 Posts: 107 Location: India
|
|
|
|
Input File:
(Included line numbers for reference)
| Code: |
12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345
FOFAC001 18310/0030
------------------------- AGENT INFORMATION -------------------------
Job Type: UNIX_JOB
Agent: LINUX_01ABHK
Userid: UMIKE001
--------------------------- TRIGGERED JOBS ----------------------------
JOB=BOFAC001 SCHID=000 QTM=0100 LEADTM=0000 SUBMTM=0000
JOB=COFAC001 SCHID=000 QTM=0100 LEADTM=0000 SUBMTM=0000
JOB=DOFAC001 SCHID=000 QTM=0100 LEADTM=0000 SUBMTM=0000
FOFAC002 18309/1530
------------------------- AGENT INFORMATION -------------------------
Job Type: UNIX_JOB
Agent: LINUX_02ABHK
Userid: UMIKE002
--------------------------- TRIGGERED JOBS ----------------------------
JOB=KOFAC001 SCHID=000 QTM=0100 LEADTM=0000 SUBMTM=0000
JOB=MOFAC001 SCHID=000 QTM=0100 LEADTM=0000 SUBMTM=0000 |
Output:
(Included line numbers for reference)
| Code: |
12345678901234567890123456789012345678901234567890123456789012345678901234567890
JOBNAME ,LASTRUN ,JOBTYPE ,AGENT ,USERID ,TRIGGERED JOBS
FOFAC001,18310/0030,UNIX_JOB,LINUX_01ABHK,UMIKE001,BOFAC001;COFAC001;DOFAC001
FOFAC002,18309/1530,UNIX_JOB,LINUX_02ABHK,UMIKE002,KOFAC001;MOFAC001
|
I tried the below code and was able to group records and include corresponding jobname for each line and line number. Please help. Thank you.
| Code: |
//SYSIN DD *
OPTION COPY
INREC IFTHEN=(WHEN=GROUP,
BEGIN=(2,3,CH,NE,C' '),PUSH=(85:2,8))
OUTREC IFTHEN=(WHEN=INIT,OVERLAY=(95:SEQNUM,3,ZD,RESTART=(85,8)))
/* |
Sorry couldn't update my last post, simplifying the question and reposting it again. Thank you! |
|
| Back to top |
|
 |
hiravibk Warnings : 1 Active User
Joined: 14 Dec 2008 Posts: 107 Location: India
|
|
|
|
I have the below input file with data for jobs spanning to multiple lines.
1) The file below has data for two jobs FOFAC001 and FOFAC002. Each job has two sections, 'AGENT INFORMATION' and 'TRIGGERED JOBS' sections.
2) I need Job Type, Agent and Userid from AGENT INFORMATION section and jobs in TRIGGERED JOBS section for each job in a CSV, along with the last run time of the job present in the first line of each job.
3) Only condition is each job can have several triggered jobs.
Please help. Thank you! |
|
| Back to top |
|
 |
expat
Global Moderator

Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
DO NOT post the same question on multiple forums.
The responders on here are the same as those as on the other forum.
This topic has been locked
Also, this is a repeat post of a previous topic in this forum from which you did not receive any replies. Why do you think that reposting the exact same thing will illicit any more response. If we can help we will, if we can't we can't, one of the rules of forum life. |
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2454 Location: Hampshire, UK
|
|
|
|
| Topic in beginner's forum deleted. |
|
| Back to top |
|
 |
|
|
 |
All times are GMT + 6 Hours |
|