While running a query with contains function in Windows XP, I met an error messages like this -
SQL21000N DB2 Net Search Extender was not installed or not configured properly. SQLSTATE=42724
Would you please let me know how to solve ?
DB21085I Instance "DB2" "32" bit level ID "02010107" DB2 code release
"DB2 v18.104.22.1686", "s060629", "NT32" and fixpack "0"
This topic has been locked.
Pinned topic contains function in DB2 9
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Re: contains function in DB2 92006-09-27T03:16:42ZThis is the accepted answer. This is the accepted answer.To use CONTAINS function, Net Search Extender is needed. Net Search Extender is included in all editions at no aditional charge.
You must first enable a database for net search.
If you go into the control center, right click on the database and near the bottem you will see "Net Search Extender -> Enable Database for Text".
Or from the command line you can run "db2text ENABLE DATABASE FOR TEXT CONNECT dbname";
But while enabling "Net Search Extender", I met a error message like..
CTE0296 Can't find "cteccadm" Library at "hostname". Verify installation for DB2 Net Search Extender.
Re: contains function in DB2 92006-09-27T07:16:11ZThis is the accepted answer. This is the accepted answer.
Re: contains function in DB2 92006-09-28T02:52:11ZThis is the accepted answer. This is the accepted answer.
Re: contains function in DB2 92006-09-28T07:40:33ZThis is the accepted answer. This is the accepted answer.
- kangc13 1200007PXT
On the main express-c download page look for DB2 9 net search extender:
Re: contains function in DB2 92012-12-09T13:56:58ZThis is the accepted answer. This is the accepted answer.How about the syntax of CONTAINS ?
I got this error: SQL0104N An unexpected token SQLSTATE=42601
select * from table CONTAINS (FIELD, "input")=1
Re: contains function in DB2 92012-12-09T14:41:37ZThis is the accepted answer. This is the accepted answer.I missing the WHERE
should be : SELECT * from table where CONTAINS (F2, 'input')=1
But got another error:
SQL21000N A text search option is not installed or not properly configured.