Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Mearging files with resequencing
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 311
Location: Inside the SPEW (Cincinnati OH USA)

PostPosted: Thu Jun 10, 2010 4:56 pm    Post subject:
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    Post subject:
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

Senior Member


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

PostPosted: Thu Jun 10, 2010 6:05 pm    Post subject:
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

Senior Member


Joined: 14 Mar 2007
Posts: 10681
Location: italy

PostPosted: Thu Jun 10, 2010 6:21 pm    Post subject: Reply to: Mearging files with resequencing
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: 311
Location: Inside the SPEW (Cincinnati OH USA)

PostPosted: Thu Jun 10, 2010 6:49 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compare multiple files using JCL/Rexx... tanvi110788 JCL & VSAM 4 Tue May 19, 2020 5:47 pm
No new posts Need help to concatenate files with w... ssuthagar All Other Mainframe Topics 3 Fri May 15, 2020 1:39 am
No new posts Java Batch launcher JVMPRC86 does not... harisukumaran IBM Tools 2 Wed Apr 15, 2020 12:37 am
No new posts Is it possible to compare two files i... kushkush DFSORT/ICETOOL 3 Mon Apr 13, 2020 8:33 am
No new posts Substring for 2 files in Sort JCL Shubhendu Chakraborty DFSORT/ICETOOL 1 Wed Nov 20, 2019 11:07 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us