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.
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.