Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96

    Unanswered: Oracle ctxsys.context indexes

    Hi there!
    In Oracle, it allow to create a text index using ctxsys.context

    create table mytable(id number primary key, docs clob);

    insert into mytable values(111555,'this text will be indexed');
    insert into mytable values(111556,'this is a default datastore example');
    commit;

    create index myindex on mytable(docs)
    indextype is ctxsys.context
    parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE');

    Please find below here is the url for Oracle text base index
    http://docs.oracle.com/cd/B28359_01/...d.htm#i1006972

    Is there any similarity way to create a text base index in db2?

    Thank you

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It's possible after you install and configure the DB2 Text Search feature: http://www-01.ibm.com/support/knowle...n.html?lang=en
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96
    Thanks for reply n_i.
    I have follow the instruction to install db2 text search by using db2 wizard from the db2 10.5 express c installer on the existing instance by choosing on Work with existing from the installer wizard.
    Next I have registered the the DLL by running it on the windows command prompt as below here :

    c:\windows\SysWOW64\regsvr32 /s c:\Program_Files\IBM\SQLLIB\bin\ibmdadb2.dll

    I stop the db2instance and restart it again.

    I try to compile the db2 text search index,

    create index myindex for text on mytable(docs);

    It give an errors as follow
    An unexpected token "FOR TEXT" was found following "myindex". Expected tokens may include: "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.18.60

    Do I miss some steps in between?

    Thanks in advance!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •