1.  Home
  2. MIDRANGE-L
  3. October 2009

RE: DBCS issues revisited

In V6R1 you can put a WHERE clause on an index. You can also have the
index keys be expressions. The former is equivalent to an S/O logical
so
far as selectivity is concerned. It is still probably specific to the
iSeries.

There is no way that I know of to have a subset of the columns in an
index. That is still the province of LFs on the iSeries.

Thanks, Rob and Vern, for your responses. Since we're about a billion
releases back from 6.1 (OK, only two), I'll roll an LF solution for these.
I wanted a pure SQL solution since that's supposed to be the preferred
approach lately... but alas!

Regards,

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
It's better to be rich and healthy than poor and sick.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.