ssolberg
VIP Member
RE: More on DW data selection
You are correct but it is easy to get what you want using OR's in your
selections such as: (multiple fields needed in selections)
MYFLD EQ *VALUES 123 124
AND TYPE EQ *VALUES X Y
AND OTHER EQ XYZ
OR MYFLD EQ *VALUES 125 126
AND TYPE EQ *VALUES X Y
AND OTHER EQ XYZ
You have to "duplicate" the other criteria again with an OR in between and
you will now get MYFLD equal to 123, 124, 125, 126 in your report.
Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)
You are correct but it is easy to get what you want using OR's in your
selections such as: (multiple fields needed in selections)
MYFLD EQ *VALUES 123 124
AND TYPE EQ *VALUES X Y
AND OTHER EQ XYZ
OR MYFLD EQ *VALUES 125 126
AND TYPE EQ *VALUES X Y
AND OTHER EQ XYZ
You have to "duplicate" the other criteria again with an OR in between and
you will now get MYFLD equal to 123, 124, 125, 126 in your report.
Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)