Using %NOT in OPNQRYF

120 pts.
Tags:
%NOT
OPNQRYF
QRYSLT
I know that %NOT is a function available for using in the qryslt parameter of opnqryf but I can't figure out how to code it. I would like to eliminate all records with a range in the middle of the possible range, for example, select all facilities except those is the range of 600 - 699. Is this possible?

Answer Wiki

Thanks. We'll let you know when a new response is added.

The %NOT function is not a comparison function, it accepts a string argument and returns a bitwise logical not value of the string argument.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • WaltZ400
    If you use a %RANGE function in OPNQRYF it has to be preceded by an equal operand (= or *eq). Why don't you just say QRYSLT('facility 699')?
    655 pointsBadges:
    report
  • WaltZ400
    If you use a %RANGE function in OPNQRYF it has to be preceded by an equal operand (= or *eq). Why don’t you just say QRYSLT(’facility *lt 600 *or facility *gt 699′)?
    655 pointsBadges:
    report
  • CLKelly
    Thank you Kevleemor and WaltZ400. Since I'm working within the constraints of a selection program that I'd like to enhance to allow excludes as well as includes it gets a little tricky to use WaltZ400's suggestion. It is what I would do if I were writing from scratch. Kevleemor, could you give an example of using %NOT? I have yet to find anythng in any of my online searches. Many Thanks!
    120 pointsBadges:
    report
  • kevleemor
    HI CLKelly, I don't have an example of how to use the %NOT builtin function. But I can show you the IBM OPNQRYF reference page where the discription resides: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/cl/opnqryf.htm This page will show you all the capibilities of Open Query File. Kevin
    605 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following