Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 1187
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
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us