Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Move the distinc records of 2 Seq. files into One Seq file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
rajat
Warnings : 1

New User


Joined: 11 Nov 2006
Posts: 1
Location: india

PostPosted: Wed Nov 22, 2006 4:00 pm    Post subject: Move the distinc records of 2 Seq. files into One Seq file
Reply with quote

can any one tell me how we can move the distinc records of 2 seq.file into other file seq.file

WARNING: TITLE EDITED
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1190
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 4:21 pm    Post subject:
Reply with quote

Hi rajat
We can use dfsort for this
Please describe which record u want to o/p file .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Wed Nov 22, 2006 9:43 pm    Post subject:
Reply with quote

rajat,

You haven't given enough information for anyone to help you. Please give a more complete description of what you're trying to do. Show an example of the records in each input file and the records you expect for output. Give the RECFM and LRECL of the input files.
Back to top
View user's profile Send private message
Narismha

New User


Joined: 22 Nov 2006
Posts: 23
Location: Mumbai

PostPosted: Thu Nov 23, 2006 10:00 am    Post subject: can any one tell me how we can move the distinc records of 2
Reply with quote

Hi Rajat,

My assumption is two files are same length. First merge the 2 files then you will get one file with duplicates. Then sort that file by using sum fields = none (it will delete duplicates).i.e you will get distinct records.

Please correct me if i am wrong .

Thanks
-Narisimha
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Thu Nov 23, 2006 9:27 pm    Post subject:
Reply with quote

Narisimha said
Quote:
Please correct me if i am wrong.


It's difficult to say if you're right or wrong given that we don't know what Rajat actually wants to do. However, it's not clear what you mean by "merge the 2 files, ... then sort". You don't need a MERGE and SORT to remove duplicates. Files can only be merged if they are already in sorted order in which case you could remove the duplicates with just a MERGE. If the files are not already sorted, then you could remove the duplicates with just a SORT by concatenating the two input files. But we don't really know what Rajat wants, so let's wait until Rajat tells us.
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
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 Tue Apr 17, 2018 10:42 pm
No new posts Comparing two sequential files Mohan Kothakota COBOL Programming 14 Mon Apr 16, 2018 6:35 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts converting a mainframe file with ASA ... Lynne Schuler All Other Mainframe Topics 5 Wed Apr 04, 2018 9:44 am
No new posts Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm

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