Re: DFSORT - AND/OR mystery

2021-07-31 Thread Bernd Oppolzer
FWIW, the offset at number 3, second example, 4th line, is 99, not 98. Maybe this is part of the problem. Kind regards Bernd Am 30.07.2021 um 17:45 schrieb Radoslaw Skorupka: W dniu 30.07.2021 o 17:33, Paul Gilmartin pisze: On Fri, 30 Jul 2021 09:54:51 -0500, Mike Schwab wrote: Try 5

Re: DFSORT - AND/OR mystery

2021-07-31 Thread Radoslaw Skorupka
W dniu 30.07.2021 o 19:35, Sri h Kolusu pisze: 3. I found another mystery, which seems to be APARable: But this statement gives zero records. Note, I added "OR" conditions, so it cannot narrow the output. Radoslaw, I would respectfully disagree with that statement. I explained the quirks

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Sri h Kolusu
> 3. I found another mystery, which seems to be APARable: > But this statement gives zero records. Note, I added "OR" conditions, so it cannot narrow the output. Radoslaw, I would respectfully disagree with that statement. I explained the quirks of having Variable record lengths have on the

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Sri h Kolusu
> What's DFSORT's operator precedence? Was it necessary to bracket the > conjunctions in order that they have higher precedence than > the alternations? Gil, I vaguely remember that we went over this before. Any way here is DFSORT's operator precedence. "AND statements are evaluated before OR

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Radoslaw Skorupka
W dniu 30.07.2021 o 17:45, Radoslaw Skorupka pisze: W dniu 30.07.2021 o 17:33, Paul Gilmartin pisze: On Fri, 30 Jul 2021 09:54:51 -0500, Mike Schwab wrote: Try 5 pairs of conditions? INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'),

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Sri h Kolusu
> The input contains '0102' and '0205' records and simple statement with only one type show expected output. Radoslaw, The given conditions should work , however you should realize that IRRDB00 output is record format V and the length of the record is stored in RDW. So a 0102 record with

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Radoslaw Skorupka
W dniu 30.07.2021 o 17:33, Paul Gilmartin pisze: On Fri, 30 Jul 2021 09:54:51 -0500, Mike Schwab wrote: Try 5 pairs of conditions? INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'),

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Paul Gilmartin
On Fri, 30 Jul 2021 09:54:51 -0500, Mike Schwab wrote: >Try 5 pairs of conditions? >INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), > OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'), > OR,(5,4,CH,EQ,C'0205',AND,93,3,CH,EQ,C'YES'), >

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Mike Schwab
Try 5 pairs of conditions? INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,93,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,98,3,CH,EQ,C'YES'),

DFSORT - AND/OR mystery

2021-07-30 Thread Radoslaw Skorupka
The following statement is syntactically correct: INCLUDE COND=((5,4,CH,EQ,C'0205',AND,(83,3,CH,EQ,C'YES',OR,   88,3,CH,EQ,C'YES',OR,   93,3,CH,EQ,C'YES',OR,   98,3,CH,EQ,C'YES')),