× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Are all those fields (fld1, fld2, etc) character fields?  If one of them is numeric, then the operand should not be enclosed in quotes.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 1/7/2021 6:16 AM, techie21 IT wrote:
Hi,

In one of my CL program I am getting this error in OPNQRYF statement.

*Operand for *EQ function not valid.*

OPNQRYF FILE((QTEMP/f1)) QRYSLT('fld1 *EQ "AB" *AND fld2 *EQ "ABCD" *AND
fld3 *EQ " " *AND fld4 *EQ "06012021" ')

And additional message stating cause on pressing 'F1' for above error
message is

Message ID :- CPD3131 Severity : 30
Message Type:- Diagnostic




"The operator or built-in function *EQ, was specified at position 52 in the
expression on the QRYSLT parameter.If the error occurred on the MAPFLD
parameter,the expression was specified for the definition of field *N. For
the %Range,%VALUES,and %WLDCRD built -in functions,the error may be caused
by the first operand for the *EQ operator that is associated with the built
-in function. Conditions that can cause this error includes:-.......
........
......
................

So any idea what is wrong going here in my OPNQRYF statement?


Thanks much...
------------------------


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.