RE: IBM User Profiles -- MIDRANGE-L

Over the years, I found that this construct was pretty easily understood by most folks.
"NOT (This OR That)"

I'm sure we've all seen some (almost?) undecipherable WHERE clauses. I know I worked with a person who could come up with a doozy of one.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of VERNON HAMBERG Owner via MIDRANGE-L
Sent: Monday, July 15, 2024 8:55 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>; midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: IBM User Profiles

Hey, if you're already a negative person, aren't double negatives even better? :)

I had a manager who got lost in the path of some of my WHERE clauses - I think that I prefer now to use a set of OR'd positive tests, then put them in parentheses with a NOT in front. At lease, I think that's my preference.

Of course, things get interesting if there is a potential mix of positive and negative logical tests.

Cheers
Vern

On Mon, 15 Jul, 2024 at 10:38 AM, Bryan Dietz <bdietz400@xxxxxxxxx> wrote:

To: midrange-l@xxxxxxxxxxxxxxxxxx

i always hated the inverse-logic fields, sometimes my brain just cramps up.

https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Ftse4.mm.bing.net%2Fth%3Fid%3DOIP.m-dZYdbeVWR6c4vSNxMQngHaI1%26pid%3DApi&f=1&ipt=a85c8ae8fc6f8441458f376fac76fbce2eb9dea5290fece35ca9ac8337a7f8fc&ipo=images

(hope it goes thru)

Bryan

Jack Woehr via MIDRANGE-L wrote on 7/15/2024 8:31 AM:

The YES in the column NO_PASSWORD_INDICATOR means "No Password".
In other words, YES means NO.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.