RE: Qryslt - %values

["Bob Cozzi \(RPGIV\)" <cozzi@xxxxxxxxx>]

That's SQL Syntax!!! :)

Bob Cozzi
cozzi@rpgiv.com
Visit the new on-line iSeries Forums at: http://www.rpgiv.com/forum

> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]
On
> Behalf Of rob@dekko.com
> Sent: Tuesday, November 27, 2001 9:21 AM
> To: rpg400-l@midrange.com
> Subject: Re: Qryslt - %values
>
>
> I use the following:
> SELECT * FROM datdivf/iic WHERE iclas not in('TT','1')
>
> Rob Berendt
>
> ==================
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
>
>
>
>                     Anita Imbrescia
>                     <Anita.Imbrescia@con       To:     "'rpg400-
> l@midrange.com'" <rpg400-l@midrange.com>
>                     sprod.com>                 cc:
>                     Sent by:                   Fax to:
>                     rpg400-l-admin@midra       Subject:     Qryslt -
%values
>                     nge.com
>
>
>                     11/27/2001 08:58 AM
>                     Please respond to
>                     rpg400-l
>
>
>
>
>
>
> I am trying to change a CL to include 2 values.  It works when I do
> =%VALUES
> but cannot get the not equal to work.  I try <> and *NE and it is not
> working.  I am researching but cannot find this. I feel sure it is the
> syntax for NE.  Can anyone give me any help on this?
>
>
> Thank you.
>
> Anita Imbrescia
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.