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

[boothm@xxxxxxx]

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?



In <4.1.19990214143906.0092fd60@mail.execpc.com>, on 02/14/99 
   at 02:41 PM, Pete Hall <pbhall@execpc.com> said:

>Try copying the logical to a temporary file:
>  CPYF LGLFILE MYLIB/TMPPF CRTFILE(*YES)

>Then DSPPFM MYLIB/TMPPF and see what's in there. This is the data that
>your program is working with. I'd wager an inconsequential sum that the
>temporary file is empty.
>Pete Hall
>pbhall@execpc.com

-- 
-----------------------------------------------------------
boothm@ibm.net
Booth Martin
-----------------------------------------------------------

+---
| 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
+---