Re: Omit/select in a logical file's dds

[Pat Barber <MBOCEANSIDE@xxxxxxxxxxxxxxxxxxxxxxxxxxx>]

boothm@ibm.net wrote:
> 
> I was pretty worried I'd lose an inconsequential sum...  the file has the 
>same data set I expected to find.
> 
> But it raises a question:
> 
> Lets say a physical file has five records, all with a field filled with 
>"SAMMY", and a second field filled with a sequential number, 1 through 5.  
>Further, lets say there is a logical built over the file, with the field 
>holding the "SAMMY"s as it's only key, and Omit on any record with a 1 or a 3 
>in the sequential field.  This would leave record 2, 4, and 5 in the logical 
>file.
> 
> If I chain to that file with "SAMMY" will I get a hit?  If so, on which 
>record?

All things being equal... record 2 will be first found...
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---