Re: DDS Logical - Omit Pos 17 and ALL

Jeff,
The last line actually has no effect on the records selected.
What it does is indicate that *any* record that does not meet your select criteria will be omitted.
That is implied by the select criteria, but some people prefer to have it stated explicitly.



Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3









----- Original Message ----
From: "jstevens@xxxxxxxxxxxxxx" <jstevens@xxxxxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Sent: Monday, August 13, 2007 4:41:49 PM
Subject: DDS Logical - Omit Pos 17 and ALL


I have an old logical file that I'm trying to understand. There are some
selects on it - that's not the issue. The issue is the "Omit" - "O" in
position 17, and the ALL keyword in the functions (column 45).

Here's what the DDS manual says about it...
If you do not specify the ALL keyword, the action taken for the records
that do not meet the values is
the converse of the type of the last statement specified. Records that do
not meet selection values are
omitted, and records that do not meet omission values are selected.


The code is like this...
...
A S CHWARN COMP(EQ 'C')
A CHSDAT COMP(NE 0)
A CHAMT COMP(NE 0)
A O ALL

Well, I not understanding what the manual is saying, so, my question is -
What's the last line for? And, what's the ALL Keyword for?

Thanks!

Jeff Stevens
Mize, Houser & Co. P.A.
913 451 1882
JStevens@xxxxxxxxxxxxxx