The sorting and selection parameters would normally be entered on the JOINKEYS
statements in the sort SYSIN. For example:
JOINKEYS FILE=F1,
FIELDS=(1,12,A),
SORTED
JOINKEYS FILE=F2,
FIELDS=(277,12,A),
INCLUDE=(280,1,FS,NE,NUM,
AND,637,1,CH,NE,C'R',
AND,638,2,PD,GT,0)
INCLUDE/OMIT is supported. INREC is not. SORT is the same fields as you're
joining on. OPTION COPY is denoted by "SORTED".
You can't JOIN and sort on different keys; to do that you'd have to pre-sort
the file, then use SORTED.
Note, however, when it comes to sort products, just because it isn't documented
doesn't mean it won't work.
-----Original Message-----
From: IBM Mainframe Discussion List <[email protected]> On Behalf Of
Farley, Peter
Sent: Monday, May 6, 2024 12:17 PM
To: [email protected]
Subject: SYNCSORT question - how to specify different sorting parameters for
JOIN input files F1/F2
This is a question specific to the SYNCSORT product, not a general SORT
question.
I do not have access to question the Syncsort support team, and I cannot see
from the latest programmer's guide for the product (Syncsort MFX Programmer's
Guide, Version 3.1) what the answer to this question is, so I am asking here
for help from anyone already knowledgeable in the product.
IBM's DFSORT allows one to specify DD statements JNF1CNTL and JNF2CNTL to enter
different sorting parameters for the two JOIN input files. As far as I can
tell from both manual reading and from a few practical attempts, SYNCSORT does
NOT support those DD statements.
How does one perform the DFSORT-equivalent function of JNF1CNTL and JNF2CNTL
using SYNCSORT? I.E., how do I enter sorting control statements (INCLUDE/OMIT.
INREC, SORT or OPTION COPY, etc.) separately for JOIN files F1 and F2?
TIA for any light you can shed on this specific area.
Peter
This message and any attachments are intended only for the use of the addressee
and may contain information that is privileged and confidential. If the reader
of the message is not the intended recipient or an authorized representative of
the intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication
in error, please notify us immediately by e-mail and delete the message and any
attachments from your system.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
