×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 11-Oct-2016 16:14 -0500, Gerald Magnuson wrote:
I have a single field in a single table set to index (db2 on i).
can I somehow create a text index over multiple columns in one
table, or even better, over two tables?
or.. do I just need to create multiple indexes?
From my *very limited* toying with the 5733-OMF OmniFind® Text Search
Server for DB2® for i when that was available to me [AFaIK, no system to
which I have access presently, has the feature installed], I recall
invoking the _create_ procedure once per column; then the SCORING and
CONTAINS queries were directed against those specific columns for which
the index previously had been created. A query can have multiple
table-references, e.g. a join, but I recall there were some limitations
on how the data could be combined along with the use of multiple
text-search query requests.
Might a specific contrived example of DDL and some data be provided,
along with what kind of inquiry needs to be made [and the expected results]?
This mailing list archive is Copyright 1997-2025 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.
midrange.com
