SELECT AND OMIT LEVEL IN NON JOIN LOGICAL FILE

Selecting and omitting records using logical files

The system can select and omit records when using a logical file. This can help you to exclude records in a file for processing convenience or for security.


 http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fdbp%2Frbafosorec.htm

A          S ITMNBR                    VALUES(301542 306902 382101 422109 +
     A                                      431652 486592 502356 556608 590307)

--------------------------------

 A          S DPTNBR                    CMP(NE 12)

-----------------------------

 You use select/omit fields to tell
the operating system how to select or omit records when your program retrieves
them using this record format. 

REFERENCE

-------------------------------------