DB2 NET SEARCH / 5765F3800 / 970 - DB2

Here is the corrected recreate 
 
DB2 "CREATE TABLE DOCVIEWR ( DOCKEY VARCHAR(200) FOR BIT DATA 
NOT NULL , DOCTEXT CLOB(51200) LOGGED NOT COMPACT ) DISTRIBUTE 
BY HASH(DOCKEY) IN DOCVIEWR_TS" 
 
DB2 "ALTER TABLE DOCVIEWR ADD CONSTRAINT PK PRIMARY KEY 
(DOCKEY)" 
 
 
db2text "create index TEXT02R.CNINX_DOCVIEWER_DOC for text on 
docviewr (doctext) format TEXT connect to sample" 
 
 
db2 "Insert Into DocViewr Values('DocData_data://Clinical 
Notes/Clinical Note+3656405:264907976:4', 'This is a sentence 
mentioning both Remicade and never.')" 
 
db2text Update Index Text02R.CNInx_DocViewer_Doc For Text 
connect to sample 
 
/* This won't match on the document inserted above. */ 
db2 "SELECT * FROM DOCVIEWR TEXTTABLE where CONTAINS(DOCTEXT, 
'((\"never\" IN SAME SENTENCE AS \"Remicade\" ) | 
((\"infliximab\", \"Remicade\") IN SAME SENTENCE AS \"decision\" 
))') = 1" 
 
/* But just swapping the order of the arguments to the ?|? 
operator in the search argument it will then match on that 
document. */ 
db2 "SELECT * FROM DOCVIEWR TEXTTABLE where CONTAINS(DOCTEXT, 
'(((\"infliximab\", \"Remicade\") IN SAME SENTENCE AS 
\"decision\" ) | (\"never\" IN SAME SENTENCE AS \"Remicade\" 
))') = 1"

**************************************************************** 
* USERS AFFECTED:                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* INCORRECT RESULTS USEING CONTAINS IN THE SAME SENTENCE       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V97fp4                                            * 
****************************************************************

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

not known / see Local fix

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

17.08.2010
28.04.2011
28.04.2011

9.7.FP4