DFSORT and SYNCSORT options are just not the same for this feature.
The wording would seem to imply that *any* comparison will be treated as false.
The SYNCSORT description for VLTESTI=2 seems to imply the same behavior (note
the last sentence in this quote):
"When VLTESTI=2 is specified, MFX will treat comparisons to fields not
completely contained within the record as false and decide a record’s status
for inclusion or omission from fields that are available. If all fields are not
present, the record will be processed as having failed the comparison. MFX will
omit the record if INCLUDE is being used or include the record if OMIT has been
specified."
There is a full suite of field comparison operators in both SORT programs. EQ,
NE, LT, LE, GT, GE, and some specialty operators like SS for substring compare.
Peter
-----Original Message-----
From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of
Paul Gilmartin
Sent: Wednesday, September 9, 2020 2:20 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Syncsort include/omit beyond record
On Wed, 9 Sep 2020 17:19:55 +0000, Farley, Peter x23353 wrote:
>Use these PARM options for SYNCSORT to allow field references beyond the
>actual input record length:
>
>PARM=VLLTEST=2,VLTESTI=2'
>
>One of your VB input records is less than 17 bytes long (21 - 4 = 17).
>
A Google search seems to find those as SYNCSORT options but not as DFSORT
options. Is that right? But on:
https://www.ibm.com/support/knowledgecenter/SSLTBW_2.4.0/com.ibm.zos.v2r4.iceg200/ice2cg_Short_control_fields1.htm
Another way you can prevent DFSORT from terminating for VB records
with short compare fields, if appropriate, is by specifying the VLSHRT
option. For example:
OPTION COPY,VLSHRT
INCLUDE COND=(21,8,CH,EQ,C'Type 200')
VLSHRT tells DFSORT to treat any comparison involving a short field as
false.
In this example, any records less than 28 bytes are not included.
What other comparison operators are available. For example, I'd be interested
in whether:
OMIT COND=(21,8,CH,NE,C'Type 200') ... causes short records *not* to be
omitted because "NE" is false.
--
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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN
