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

Mearging files with resequencing


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 419
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Thu Jun 10, 2010 4:56 pm
Reply with quote

Isn't this a simple first 'occurence' wins situation?
Back to top
View user's profile Send private message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Thu Jun 10, 2010 5:03 pm
Reply with quote

anshul , sorry i dint notice icon_exclaim.gif , you are correct icon_biggrin.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Jun 10, 2010 6:05 pm
Reply with quote

Quote:
Chanin Smoker => "I hate cigaretes .... thats why i burn them down "

There s always a smater way to express urself
But one should not advocate for wrong things ! (Well, let's don't talk about "perception" here, some things are beyond that because they are facts.)
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Jun 10, 2010 6:21 pm
Reply with quote

Quote:
Step1 : Concatenate and sort on ur key
step2 : Generate the sequence number and replace ur KEY with it .


the TS request was simply ...
concatenate file1 file2 file 3 and create e unique sequence number
as seen from the example of the output file...

sorting as suggested will mix up the records

so forget about SORTING anything,
any suggestion about sort is ...
1) a misunderstanding of the initial requirement
2) a useless waste of resources in sorting what has already been sorted
( see my previous posts and the replies that follow them )
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 419
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Thu Jun 10, 2010 6:49 pm
Reply with quote

enrico,

great pattern recognition!
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
No new posts How to append a PS file into multiple... JCL & VSAM 3
Search our Forums:

Back to Top