Re: dds

The selects are 'or'd so you should get everything
where the J1Stat is NE 60 as well as all your 
accounts.  Is that what is happening?
If you only want those accounts where
the status is ne 60, try omitting where it
is equal to 60 thus:
007.00      A          R J1REC                     PFILE(
008.00
011.00      A       K J1NGLN
012.00     
A*****===========================================================
013.00      A     S J1ACCT                    CMP(EQ '50093')
014.00      A     S J1ACCT                    CMP(EQ '50095')
015.00      A     S J1ACCT                    CMP(EQ '50195')
016.00      A     S J1ACCT                    CMP(EQ '50295')
017.00      A     O J1STAT                    CMP(EQ 60)
018.00     
A*****===========================================================



>>> steema@xxxxxxxxxxxxx 3/22/2006 11:02:20 AM >>>
mine only works w/ one choice.
when I add more, it selected everything in the file

007.00      A          R J1REC                     PFILE(
008.00
011.00      A       K J1NGLN
012.00     
A*****===========================================================
013.00      A     S J1ACCT                    CMP(EQ '50093')
014.00      A     S J1ACCT                    CMP(EQ '50095')
015.00      A     S J1ACCT                    CMP(EQ '50195')
016.00      A     S J1ACCT                    CMP(EQ '50295')
017.00      A     S J1STAT                    CMP(NE 60)
018.00     
A*****===========================================================
> You mean like this:
>
>       A          K IVPITM
>      A          S IVCLAS                    COMP(EQ '500')
>      A          S IVCLAS                    COMP(EQ '501')
>      A          S IVCLAS                    COMP(EQ '600')
>      A          S IVCLAS                    COMP(EQ '605')
>      A          S IVCLAS                    COMP(EQ '502')
>
>
> This works for me.  I get these classes and no others.
>
>
> Perhaps I misunderstood the question.  Maybe a copy of the DDS might
help.
>
>
> Thanks.
>       * Jerry C. Adams
> *iSeries Programmer/Analyst
> B&W Wholesale Distributors, Inc.* *
> voice
>       615.995.7024
> fax
>       615.995.1201
> email
>       jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>
>
>
>
> steema@xxxxxxxxxxxxx wrote:
>
>>simple question, i just forget, if I want to Select on say 3
specific
>>accounts, it;s not range, but 3 S statements in a row doesn't work.
Need
>>to lift all the Walmart accts for a comparison program.
>>
>>
>
> --
> 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.
>
>