View previous topic :: View next topic
|
Author |
Message |
nazia.lalani Warnings : 1 New User
Joined: 20 Mar 2009 Posts: 25 Location: hyderabad
|
|
|
|
Hi,
Can anybody say if can i use JOINKEYS in SORT instead of SYNCSORT bcoz in my organziation we dont have an option to submit using SYNCSORT.
Actually my Requirement is, am having two input files and i need to compare those files and generate the third file with Matched records.
Condition::
Input file1:
contians records with only one column as "Number" (size is 668)
Input file2:
contians records with more than One column (size is 668)
when both files are compared i need to get the matched records from second file with total columns.
bcoz inputfile1 contains only few records and second file contains millions of records.
So can anybody give the suggestion how to proceed. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
The first thing we really need to establish here is exactly which sort product is in use, and also the release level because the solution for sort related questions may vary from product to product, please ensure that you state clearly which sort product you are using.
If you are not sure, then by running a simple sort step shown below, you will be able to find out for yourself.
If the messages start with ICE then your product is DFSORT and the topic will be moved to the DFSORT forum by one of the moderators. Please also post the output of the complete line which has a message code ICE201I, as this will enable our DFSORT experts to determine which release of DFSORT that you have installed. This may also affect the solution offered.
If the messages start with WER or SYT then the product is SYNCSORT and the topic will remain in the JCL forum. Please also post the information telling which version of SYNCSORT is installed, as this may also affect the solution offered.
Thank you for taking your time to ensure that the valuable time of others is not wasted by offering inappropriate solutions which are not relevant due to the sort product being used and/or the release that is installed in your site.
Code: |
//SORTSTEP EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
ABC
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY |
You also need to give a lot more information than you already have. If you had searched the forums for help on sort you would have found that nearly every sort question requests the same information from each poster.
DSORG, RECFM and LRECL of both input files, and the expected output file.
Position, length and data format of key fields. |
|
Back to top |
|
|
nazia.lalani Warnings : 1 New User
Joined: 20 Mar 2009 Posts: 25 Location: hyderabad
|
|
|
|
Ok..thank u for u r valuable suggestions |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
You did not really make use of the comments from expat. He just directed you.
If I go by your subject line
Quote: |
Can i use JOINKEYS in SORT instead of SYNCSORT |
that, actually, does not make sense - SORT is an "alias" name given to your sort products - so that when you write PGM=SORT the default sort product gets invoked.
For a hint - JOINKEYs are available in both SyncSort and DFsort but you must have the correct version or PTF installed in order to use them. you may like to search the froum on "joinkeys" and can work through the examples you get. |
|
Back to top |
|
|
|