View previous topic :: View next topic
|
Author |
Message |
hiravibk Warnings : 1 Active User
Joined: 14 Dec 2008 Posts: 107 Location: India
|
|
|
|
I have two PS files.
The first one has data in the below format
Code: |
job1 5/12/2009
job2 5/13/2009
job3 5/10/2009
job4 5/14/2009
job5 5/12/2009
job6 5/13/2009
job7 5/10/2009
job8 5/14/2009
|
the second one has data in the following format
Code: |
job1,job5
job2,job6
job3,job7
job4,job8
|
I want the out put file like,
Code: |
job1,job5 5/12/2009
job2,job6 5/10/2009
job3,job7 5/13/2009
job4,job8 5/14/2009
|
I'm using April 2006 version of DFSORT. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use a DFSORT/ICETOOL job like the following to do what you asked for:
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//CON DD *
job1 5/12/2009
job2 5/13/2009
job3 5/10/2009
job4 5/14/2009
job5 5/12/2009
job6 5/13/2009
job7 5/10/2009
job8 5/14/2009
/*
// DD *
job1,job5
job2,job6
job3,job7
job4,job8
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SPLICE FROM(CON) TO(OUT) ON(1,4,CH) WITH(5,5)
/*
|
|
|
Back to top |
|
|
hiravibk Warnings : 1 Active User
Joined: 14 Dec 2008 Posts: 107 Location: India
|
|
|
|
It worked fine for me....Thank you much Frank.. |
|
Back to top |
|
|
|