Re: Syncsort include/omit beyond record

2020-09-09 Thread Paul Gilmartin
On Wed, 9 Sep 2020 14:31:24 -0700, Sri h Kolusu wrote: > >>>Are complicated Boolean expressions supported? > >Yes. Check this link > >https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.icea100/ice2ca_Relational_condition.htm > Thanks. I see: AND statements are e

Re: Syncsort include/omit beyond record

2020-09-09 Thread Sri h Kolusu
>>>Suppose the programmer wishes to compare to binary zeroes, Gil, Comparing to binary zeros will let you include short records who have length less than 21 bytes. But that is an easy fix. Since we are dealing with VB records, the actual length is in RDW so you can add the RDW validation in the

Re: Syncsort include/omit beyond record

2020-09-09 Thread Paul Gilmartin
On Wed, 9 Sep 2020 13:15:43 -0700, Sri h Kolusu wrote: > >VLSCMP tells DFSORT that you want to temporarily replace any missing >compare field bytes with binary zeros, thus allowing the short fields to be >validly compared (the binary zeros are not kept for the output records). > >So use the followi

Re: Syncsort include/omit beyond record

2020-09-09 Thread Sri h Kolusu
> A Google search seems to find those as SYNCSORT options but not as > DFSORT options. Is that right? But on: Gil, Both products have different parms. >>> What other comparison operators are available. For example, I'd > be interested in whether: OMIT COND=(21,8,CH,NE,C'Type 200') You need t

Re: Syncsort include/omit beyond record

2020-09-09 Thread Farley, Peter x23353
Discussion List 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 +, Farley, Peter x23353 wrote: >Use these PARM options for SYNCSORT to allow field referenc

Re: Syncsort include/omit beyond record

2020-09-09 Thread Paul Gilmartin
On Wed, 9 Sep 2020 17:19:55 +, 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

Re: Syncsort include/omit beyond record

2020-09-09 Thread Joseph Reichman
> > One of your VB input records is less than 17 bytes long (21 - 4 = 17). > > HTH > > Peter > > -Original Message- > From: IBM Mainframe Discussion List On Behalf Of > Joseph Reichman > Sent: Wednesday, September 9, 2020 11:59 AM > To: IBM-MAIN@LIS

Re: Syncsort include/omit beyond record

2020-09-09 Thread Farley, Peter x23353
Of Joseph Reichman Sent: Wednesday, September 9, 2020 11:59 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Syncsort include/omit beyond record EXTERNAL EMAIL Hi I am getting the above message on sortin being a VB record lrecl 3196 blocksize 32000 The include is Include cond=(21,1,BI,EQ,X’01’) Loo

Syncsort include/omit beyond record

2020-09-09 Thread Joseph Reichman
Hi I am getting the above message on sortin being a VB record lrecl 3196 blocksize 32000 The include is Include cond=(21,1,BI,EQ,X’01’) Looking for x’01’ in pos 21 ( including RDW) -- For IBM-MAIN subscribe / signoff / archi