RE:

["Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Rob, does your solution require you to know up front what all possible
values are (i.e., 1, 2, 3, 4...10) in order to find which ones are missing?
This wouldn't work too well then if it was a changing list of numbers every
time because there's no way you could know.

Unless I did not understand your logic there, which is possible.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, April 16, 2008 7:55 AM
To: Midrange Systems Technical Discussion
Subject: Re:

This works on V6R1

with list(counter) as 
(values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10)) 
select counter from list 
where counter not in(select thekey from qtemp/foxwell)

So if qtemp/foxwell contains 2, 3 and 5 you will get back:  1, 4, 6, 7, 8, 
9, 10


Rob Berendt