I am trying to find a way in SQL to get a list of all values that do not
exist in a field. As in...
where "value" not in (select "number" from file)
It's more complex than that, but if I can get the basics then I should be
able to expand it.
Let's say I have a file that has a field "number". It's a 3-digit field.
I know that over 800 of the 999 possible (non-zero) values are already
used. I need to know which values are not used.
I've tried using CREATE SEQUENCE and it creates a Data Area (with junk in
I suppose I could create a file of nothing but sequential numbers from 1
to whatever, but I'm hard-headed and this really shouldn't be that hard.
Am I missing something obvious? I can probably get around this particular
issue, but I'd really like to have a new technique that I can use in the
Thanks in advance,
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives