RE: Another SQL question

Wouldn't that give her all the records ?  I think she doesn't want item
33333.

Try this:

SELECT A.PZCONO, A.PZCSNO, A.PZWHID, A.PZQTOR, A.PZQTSH FROM
APLUS2FXX/ZPOFILLD A WHERE A.PZQTOR > 0 or A.PZQTSH > 0))


|-----Original Message-----
|From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
|On Behalf Of rob@xxxxxxxxx
|Sent: Monday, January 29, 2007 2:43 PM
|To: RPG programming on the AS400 / iSeries
|Subject: Re: Another SQL question
|
|Change the and to an or.
|
|Rob Berendt
|--
|Group Dekko Services, LLC
|Dept 01.073
|PO Box 2000
|Dock 108
|6928N 400E
|Kendallville, IN 46755
|http://www.dekko.com
|
|
|
|
|
|"Rowe, Sheri" <srowe@xxxxxxxxx>
|Sent by: rpg400-l-bounces@xxxxxxxxxxxx
|01/29/2007 02:39 PM
|Please respond to
|RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
|
|
|To
|<rpg400-l@xxxxxxxxxxxx>
|cc
|
|Fax to
|
|Subject
|Another SQL question
|
|
|
|
|
|
|Hi All,
|
|I would like to know the SQL syntax to exclude records in a file where
2
|fields both equal zero.  In the file below I would want all records
|except item 33333.
|
|FILEA
|ITEM        QTYORDER          QTYSHIP
|11111        0                 100
|22222        10                 0
|33333        0                  0
|44444        100               100
|
|SELECT A.PZCONO, A.PZCSNO, A.PZWHID, A.PZQTOR, A.PZQTSH FROM
|APLUS2FXX/ZPOFILLD A WHERE (NOT(A.PZQTOR = 0) and NOT(A.PZQTSH = 0))
|
|When I run this code I only get item 444444.
|
|Thanks in advance.
|
|Sheri R.
|Timex Canada
|
|
|--
|This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
|To post a message email: RPG400-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
|or email: RPG400-L-request@xxxxxxxxxxxx
|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@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
|or email: RPG400-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at http://archive.midrange.com/rpg400-l.