Re: a small query

[murali dhar <hydchap1@xxxxxxxxx>]

Hi
I need to select all records for firm=J(must
condition) .In addition 
It should include records of office=980 for
exchanges(exch) 22,24..
Iam very confused tried different combinations but
couldnt conclude anything on this..some one help me!
Thanks in adv for ur help!
Murali
--- murali dhar <hydchap1@xxxxxxxxx> 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.
> 
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree