DB2 NET SEARCH / 5765F3800 / 950 - DB2

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

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC77486 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

12.11.2010
10.01.2011
10.01.2011

9.5.FP7