On 16 Oct 2013 09:11, Gqcy wrote:
I don't know the correct search words for this...
we have several text columns we need to search over
multiple tables, multiple columns.
need like, and, or, searches...
is there a (built in) tool to help index the diverse data...
Search the InfoCenter for OmniFind. Should also be some stuff on
DeveloperWorks.
IBM i 7.1 Information Center -> e-business and Web serving -> e-business
enablers -> OmniFind Text Search Server -> Introduction
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzash/omniz_introsearchserver.htm
_i Overview of the OmniFind Text Search Server for DB2 for i i_
"OmniFind® Text Search Server for DB2® for i provides a set of
administrative stored procedures and two built-in functions: CONTAINS
and SCORE. These functions are used to search text indexes created from
documents stored in a DB2 table. The administrative stored procedures
are used to enable and disable text searching and to create, update, and
drop text indexes.
..."
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.
midrange.com
