Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
7 replies Latest Post - ‏2012-12-09T14:41:37Z by SystemAdmin
kangc13
kangc13
5 Posts
ACCEPTED ANSWER

Pinned topic contains function in DB2 9

‏2006-09-26T14:23:37Z |
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 ?

db2level

DB21085I Instance "DB2" "32" bit level ID "02010107" DB2 code release
"SQL09010"

"DB2 v9.1.0.356", "s060629", "NT32" and fixpack "0"
"DB2COPY1" "C:\SQLLIB"
Updated on 2012-12-09T14:41:37Z at 2012-12-09T14:41:37Z by SystemAdmin
  • kangc13
    kangc13
    5 Posts
    ACCEPTED ANSWER

    Re: contains function in DB2 9

    ‏2006-09-27T03:16:42Z  in response to kangc13
    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.
    • SystemAdmin
      SystemAdmin
      17917 Posts
      ACCEPTED ANSWER

      Re: contains function in DB2 9

      ‏2006-09-27T07:16:11Z  in response to kangc13
      Which version of Net Search Extender have you installed (Net Search Extender will not be installed together with DB2). To get this information type:

      db2text level
      • kangc13
        kangc13
        5 Posts
        ACCEPTED ANSWER

        Re: contains function in DB2 9

        ‏2006-09-28T02:52:11Z  in response to SystemAdmin
        I didn't install Net search extender..

        Actually, I can't find out install image for DB2 9 net search extender..

        Would you please let me know the URL for download ?
        • SystemAdmin
          SystemAdmin
          17917 Posts
          ACCEPTED ANSWER

          Re: contains function in DB2 9

          ‏2006-09-28T07:40:33Z  in response to kangc13
          Hi,

          On the main express-c download page look for DB2 9 net search extender:

          main page:
          http://www-306.ibm.com/software/data/db2/express/download.html

          download page:
          https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-dm-db2nse

          Good luck!

          Tom
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: contains function in DB2 9

    ‏2012-12-09T13:56:58Z  in response to kangc13
    How about the syntax of CONTAINS ?

    I got this error: SQL0104N An unexpected token SQLSTATE=42601

    select * from table CONTAINS (FIELD, "input")=1
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: contains function in DB2 9

    ‏2012-12-09T14:41:37Z  in response to kangc13
    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.
    SQLSTATE=42724