|
View previous topic :: View next topic
|
| Author |
Message |
bipinpeter
Active User
.jpg)
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
Hi All,
My requirement as below,
I have two files , i want to match those two files based on a key and have to create an output file.I can use SORT JOIN for this requirement.
But in the output file i want the records in the same order of input file1.Now i am getting records in sorted order of key.
Is any way? |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Please post your code and all of the relevant details of the reord format, LRECL, key positions, lengths and formats. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
1. Are you using SyncSort - as you've mentioned about "Sort JOIN"?
2. Do you have duplicates in inputs, as you talk about order of records? |
|
| Back to top |
|
|
bipinpeter
Active User
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
I am using the SYNCSORT.
I dont have duplicate records in input file. |
|
| Back to top |
|
|
bipinpeter
Active User
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
Hi,
Here is my sort card,
JOINKEYS FILE=F1,FIELDS=(51,8,A)
JOINKEYS FILE=F2,FIELDS=(41,8,A)
JOIN UNPAIRED
REFORMAT FIELDS=(F1:51,8,F2:51,8,1,5,39,1)
SORT FIELDS=COPY
After this i want the output file order as same of input file order. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
| Quote: |
| But in the output file i want the records in the same order of input file1 |
Bipin,
As you have already discovered yourself, output files will be sorted by the 'JOINKEY' after the JOIN operation . But you can always change the sort order by mentioning the output sort order in the SORT FIELDS statement.
Since you have a JOIN UNPAIRED application, you can have output records which are present in file-2 but not present in file-1. What about the sort order for these records? |
|
| Back to top |
|
|
|
|
