|
View previous topic :: View next topic
|
| Author |
Message |
smile_rajeev
New User
Joined: 22 Apr 2005
Posts: 24
|
|
|
|
Please provide me with a sort card for the following scenario in SYNCSORT.
PROBLEM:-
--------------
I have two files each having two fields and first field being the key common to both the files and
i need to have the output file first field common to both the files and 2nd field from the two files that will become totally three fields.
Example:-
----------
FILE 1:
-------
1 A
2 B
3 C
4 D
FILE 2:
-------
1 Z
2 Y
3 X
4 W
OUT PUT FILE : combination fields from both the files.
-------
1 A Z
2 B Y
3 C X
4 D W
Thanks & Regards
Rajeev |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Syncsort has JOINKEYS and REFORMAT which should do what you need. |
|
| Back to top |
|
|
smile_rajeev
New User
Joined: 22 Apr 2005
Posts: 24
|
|
|
|
Thank you for replying.
I searched for the given commands but i am not sure whether those commands could be used in the JCL sort card. I think those r applicable in DB2.
If possible cud anyone provide me a JOBcard for performing the scenario using Syncsort.
Thanks
Rajeev |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| smile_rajeev wrote: |
| I searched for the given commands but i am not sure whether those commands could be used in the JCL sort card. I think those r applicable in DB2. |
From your remark, I can assume that you do not have any Syncsort manuals, correct? |
|
| Back to top |
|
|
|
|
