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

Combining two PS


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
hiravibk
Warnings : 1

Active User


Joined: 14 Dec 2008
Posts: 107
Location: India

PostPosted: Mon May 18, 2009 11:16 am
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon May 18, 2009 8:47 pm
Reply with quote

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
View user's profile Send private message
hiravibk
Warnings : 1

Active User


Joined: 14 Dec 2008
Posts: 107
Location: India

PostPosted: Tue May 19, 2009 1:49 pm
Reply with quote

It worked fine for me....Thank you much Frank..
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 Combining Multiple Row Values into Si... DB2 3
No new posts Combining more 4 files with sorted or... DFSORT/ICETOOL 3
No new posts Combining contents of 2 files in to s... SYNCSORT 1
No new posts Combining BUILD and OVERLAY in one st... DFSORT/ICETOOL 8
No new posts Combining two sort cards JCL & VSAM 6
Search our Forums:

Back to Top