Free software training Videos

Free software training Videos
https://www.youtube.com/user/VLRTraining

List Of Best WebSites

Wednesday 2 January 2013

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

No comments:

Post a Comment