Is there an idiomatic, or at least common, expression that returns the
empty set in DB2 for i? (Or is that Db2 for i now?)

For example, maybe something like

select * from sysibm.sysdummy1 where 1 > 2

In particular, I'm interested in an expression that can be used with IN, as in

select myfield1 from mylib.myfile where myfield2 in (emptyset)

I was really hoping that it would simply be (), but that doesn't work.

So for now, the larger statement looks like

select myfield1 from mylib.myfile
where myfield2 in (select * from sysibm.sysdummy1 where 1 > 2)

Surely there's something better?

(In case you haven't guessed, the set of desired values for myfield2
is dynamically generated and won't always be empty.)

John Y.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.