Thanks!
I found more in the DDS manual about it. But I like your explaination
better. Makes sense now.
From the DDS Manual...
ALL (All) keyword?logical files only
Use this select/omit field-level keyword to specify the action to be taken
after all other select/omit
specifications have been processed for this logical file. Specify ALL with
S in position 17 to direct the
OS/400 program to select any records that do not meet any of the other
select/omit rules. Specify O in
position 17 to direct the OS/400 program to omit any records that do not
meet any of the other select/omit
rules. If specified, ALL must follow the other select/omit keywords. You
cannot specify a field name with
the ALL keyword.
This keyword has no parameters.
If you do not specify the ALL keyword, the default action taken is the
opposite of the last select/omit
specification you made for the file. If the last specification was a
select, the default is to omit all. If the last
specification was an omit, the default is to select all.
Example:
The following example shows how to specify the ALL keyword.
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
00010A S ACT COMP(EQ 3000)
00020A S ACT COMP(GT 3100)
00030A O AMT COMP(LT 0)
00040A O ALL
Jeff Stevens
Mize, Houser & Co. P.A.
913 451 1882
JStevens@xxxxxxxxxxxxxx
Jeff Young <cooljeff913@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/13/2007 04:05 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc
Subject
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
midrange.com
