var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Oracle ctxsys.context indexes
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');
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
Is there any similarity way to create a text base index in db2?
It's possible after you install and configure the DB2 Text Search feature:
"It does not work" is not a valid problem statement.
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