Re: a small query

Vern! you are really great! it worked out for
me.Thanks somuch!
The sql  query you suggested is wokring fine,bt i
dunno how to convert this sql query exactly into cpyf
selection (INCREL),anyway no problems!
Thank you,
Murali.
--- Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
> 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 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