RE: Another SQL question -- RPG400-L

I take that back...foot in mouth..you guys were right.  

I will think before I post
I will think before I post
I will think before I post
....x 10000

;->

|-----Original Message-----
|From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
|On Behalf Of Fleming, Greg (ED)
|Sent: Monday, January 29, 2007 2:47 PM
|To: RPG programming on the AS400 / iSeries
|Subject: 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.
|
|
|--
|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.