Re: a small query -- MIDRANGE-L

× 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.

This ;-) is why SQL is so nice - this is just painful, although possible. You cannot use parentheses here, so things get messy.

I believe that *AND has precedence over *OR - any *AND conditions are evaluated before the *OR's. So, in SQL, you have

PFIRM = 'J' or

(POFFIC = '980' and (PEXCH = '22' or PEXCH = '24'))

By associative properties you can figure out the 2 *OR clauses for the second part.

Personally, I'd put an SQL select into a QMQRY, the STRQMQRY with OUTPUT(*OUTFILE) OUTMBR(*FIRST *REPLACE)

HTH
Vern

At 01:27 AM 11/19/2003 -0800, you wrote:

Hi
please help me here
CPYF       FROMFILE(QS36G/GPOSF1) +
             TOFILE(QS36F/YPOSF1) +
             MBROPT(*REPLACE) CRTFILE(*YES) +

             INCREL((*IF POFFIC *EQ '980') (*AND PFIRM
+
             *EQ 'J') (*AND PEXCH *EQ '22') (*OR +

POFFIC *EQ '980') (*AND PFIRM *EQ 'J') +

(*AND PEXCH *EQ '24')) FMTOPT(*NOCHK)

this is to select office=980 firm=J and Exch=22,24.
-----------------------------------------
Now I ve to include all records with firm=J...
How do i change my query,Iam bit confused,some one
confirm  me please !
Thanks for your help in adv,
Murali.

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.