Re: QUERY!

Hi Peter,
under      Select Records     
Im already having this as follows:
AND/OR  Field             Test   Value (Field
        OFFIC             EQ     '980'       
 OR     OFFIC             EQ     'J21'       

Yes, Iam using QUERY/400. But I need to add IM of both
exch(22&JA) and put the value against exch22. And same
for 24&JB.As follows.
ACCOUNT    EXCH               INITIAL  
                              MARGIN   
JJ2102201   22           57,301,720.00  
JJ2102201   22           83,190,020.00 
=======================================



--- Peter Vidal <Peter_Vidal@xxxxxxxx> wrote:
> 
> Murali:
> 
> I do not know if I understood correctly but: are you
> referring to Query/400 or
> SQL?  If you are creating the file using QRY400, can
> you show the selection
> criteria you defined?
> 
> Conceptually, I think that you can easily do this
> (using either of the query
> alternatives mentioned before):
> 
>        EXCH              EQ     '22'
> AND    EXCH              EQ     'JA'
> OR     EXCH              EQ     '24'
> AND    EXCH              EQ     'JB'
> 
> But again, I do not know if I have all the elements
> to conclude this as a good
> approach...
> 
> Peter Vidal
> Pall Aeropower Corp.
> SR Programmer Analyst
> WWW.Pall.com
> "My religion consists of a humble admiration of the
> illimitable superior
> spirit who reveals himself in the slight details we
> are able to perceive
> with our frail and feeble mind."
> Albert Einstein
> 
> 
> 
> _______________________________________________
> 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!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools