473,396 Members | 1,927 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

indexing documents with datalink datatype

Hi all,
i have probleme in DB2 Datalink. Several microsoft documents are
stored out of Database. I use datalink datatyp to save the document
url in DB2 Text Extender.

My table with attribut conten in datalink datatyp:
CREATE TABLE htmtable_extern(text_id int CONSTRAINT htmextern_index
PRIMARY KEY not null, content DATALINK linktype url no link control);

i have insert many rows in this table.
INSERT INTO doktable_extern(1,
dlvalue('file://Diplom/Dipl_testdaten/Text/dok_ordner1/test1.doc'));
INSERT INTO doktable_extern(2,
dlvalue('file://Diplom/Dipl_testdaten/Text/dok_ordner1/test2.doc'));
INSERT INTO doktable_extern(3,
dlvalue('file://Diplom/Dipl_testdaten/Text/dok_ordner1/test3.doc'));

i want to index the content column so that i can search the documente.
Indexing:
db2tx=>enable text column doktable_extern content handle contenthandle
language german format msword indextype linguistic
updateindex update

But i get always the error message during the search.
Error message:
SQL0443N User defined function "DB2TX.CONTAINS" (specific name
"DES5A") has returned an error SQLSTATE with diagnostic text "DES38708
RC_SE_CCS_NOT_SUPPORTED. Search failed.". SQLSTATE=38708

How can i understand the error messages? I don't know what's wrong
with it? Can you give me any suggestion?

I use windows server 2000 and DB2 V8.1 mit Text Extender V8.

thank you very much and greeting from germany!

rabbit
Nov 12 '05 #1
0 1665

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: ElmoWatson | last post by:
I'm trying to use the Windows DataLink (udl) to set up a connection to a MySQL database. I've installed the 3.51 ODBC driver from the MySQL website - however, using a DataLink, it doesn't show...
3
by: chandra.somesh | last post by:
Hi I am having problem indexing large amount of textual data(in range of 200,000 to 1 million). I tried using map container but the compiler just hanged upon entering the data. On bit of...
0
by: Cornelis | last post by:
Hi, I'm storing XML documents in SQL server and I want to index them using indexing services on the XP prof. platform. There used to be a 1.0 beta version of xmlfilter.dll for windowns 2000. Is there...
1
by: Burton Wilkins | last post by:
Dear Brandon: You sent me some advice before as to how get the DataLink working, but I haven't been able to get your solution to compile: You sent me this: >Hi Burton, I was able to get the...
3
by: vonclausowitz | last post by:
Hi All, I was thinking of creating a table in my database to index all words in the database. That way I can quickly search for one or more words and the index table will return the words and...
3
by: Chung Leong | last post by:
Here's the rest of the tutorial I started earlier: Aside from text within a document, Indexing Service let you search on meta information stored in the files. For example, MusicArtist and...
4
by: ykhamitkar | last post by:
Hi there, I am using CCBill for the online payment but using my own database to save information. Now I want to identify people who have cancelled their subscriptions. Yesterday I got to...
0
by: =?Utf-8?B?djJ3aW4=?= | last post by:
Does anyone know what might cause this repeated failure message for the Indexing Service?: _______________________________ The indexing service detected that its index of metadata associated...
1
by: Server Applications | last post by:
Hello I am trying to build a system where I can full-text index documents with UTF8 or UTF16 data using Oracle Text. I am doing the filtering in a third-party component outside the database, so...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.