All,

I'm curious as to rather or not any of the IBM i CMS vendors support
OmniFind Text Search Server for DB2 for i(5733-OMF optional part of the OS
available at 6.1 and higher)

When you create an OmniFind text index over a column in a table, Omnifind
creates 4 library objects..

An SQL View (*FILE LF) and 3 SQL triggers (*PGM) over the indexed table.

There's a couple gotchas for CMS vendors,
1) The source for the view requires a qualified SQL table name, example:

call sysproc/systs_create('MYLIB','TEXTIDX'

,'MYLIB.TESTTABLE(DESCRIP)','') ;


2) The triggers are "system triggers" and trying to retrieve the SQL source
for them results in:

SQL150A 10 System trigger QDBTS_DQDBTS_STAGING_000_5000 in MYLIB
ignored.


As an FYI: the actual "text index" is in the IFS.


So, has anybody with a CMS had any luck integrating OmniFind?


I'll start the off the list. The current (v7.7) of Aldon LM(i) does not
support OmniFind.


Thanks!

Charles

This thread ...


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

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