|
View previous topic :: View next topic
|
| Author |
Message |
rajat
Warnings : 1
New User
Joined: 11 Nov 2006
Posts: 1
Location: india
|
|
|
|
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 |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi rajat
We can use dfsort for this
Please describe which record u want to o/p file . |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
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 |
|
|
Narismha
New User
Joined: 22 Nov 2006
Posts: 23
Location: Mumbai
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
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 |
|
|
|
|
