Re: a small query

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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.