- The Highlight function highlights the result of the following
search successfully:
db2 "Select p.DocID, SubStr(DB2Ext.Highlight(p.Comment,
tp.HitInformation, 'TAGS = (\"<b>\", \"</b>\")'), 1, 100) As
Highlight From DB2Ext.TextTab p,
Table(DB2Ext.TextSearch('\"computer
book\"','DB2EXT','COMMENT',0,1,cast(NULL as INTEGER), 10)) tp
Where tp.PrimKey = p.DocID"
- but it fails to highlight the result of this one:
db2 "Select p.DocID, SubStr(DB2Ext.Highlight(p.Comment,
tp.HitInformation, 'TAGS = (\"<b>\", \"</b>\")'), 1, 100) As
Highlight From DB2Ext.TextTab p,
Table(DB2Ext.TextSearch('(\"computer\"|\"computer
book\")','DB2EXT','COMMENT',0,1,cast(NULL as INTEGER), 10)) tp
Where tp.PrimKey = p.DocID"
it returns:
SQL0443N Routine "HIGHLIGHT" (specific name "") has returned an
error
SQLSTATE with diagnostic text "CTE0101 A search engine operation
failed. Reason code: "700". SQLSTATE=38701 |
****************************************************************
* USERS AFFECTED: *
* NSE 9.5 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Steps to reproduce: *
* cd ~/sqllib/samples/extenders/db2ext *
* ./nsesample NseSam *
* db2 Connect To NseSam *
* *
* - The Highlight function highlights the result of the *
* following search successfully: *
* db2 "Select p.DocID, SubStr(DB2Ext.Highlight(p.Comment, *
* tp.HitInformation, 'TAGS = (\"<b>\", \"</b>\")'), 1, 100) As *
* Highlight From DB2Ext.TextTab p, *
* Table(DB2Ext.TextSearch('\"computer *
* book\"','DB2EXT','COMMENT',0,1,cast(NULL as INTEGER), 10)) *
* tp Where tp.PrimKey = p.DocID" *
* *
* - but it fails to highlight the result of this one: *
* db2 "Select p.DocID, SubStr(DB2Ext.Highlight(p.Comment, *
* tp.HitInformation, 'TAGS = (\"<b>\", \"</b>\")'), 1, 100) As *
* Highlight From DB2Ext.TextTab p, *
* Table(DB2Ext.TextSearch('(\"computer\"|\"computer *
* book\")','DB2EXT','COMMENT',0,1,cast(NULL as INTEGER), 10)) *
* tp Where tp.PrimKey = p.DocID" *
****************************************************************
* RECOMMENDATION: *
* Upgrade to NSE 9.5 FP7 *
**************************************************************** |
