Excalibur Text Search DataBlade problem
Posted in 1999
Topics: Storage & Space Management, Data Types & Schema Design
Greetings, I'm experiencing a few problems with the etx datablade on Informix Universal Server 9.21 (Windows NT version). First off, unlike what is stated in the Informix documentation, I'm unable to create indexes on BLOB and CLOB fields. Normally the 'etx_blob_ops' and 'etx_clob_ops' operator classes should enable this, however, when I try to create a new index on such a field I simply get a 'Cannot create an index on a blob field' message. Did anyone manage to get this to work properly ? Secondly, I tried out the examples from the User's Guide, using the ifxDocDesc data type. It should be possible to store BLOB/CLOB data internally using this type (this seems to work fine), but again I cannot create an index on that field once I inserted BLOB/CLOB data; I get a 'User defined routine error' when trying to do so. Using non-blob ifxDocDesc fields (i.e. with only lvarchar data) works fine on the other hand. Finally, a minor but nonetheless troubling problem : whenever I attempt to create an etx index - regardless of the target field's data type - in an sbspace, another 'User defined routine error' pops up. Any clues as to what might be wrong would be greatly appreciated. Pointers to info (other than the Informix docs/manuals) on the etx datablade would be a big help too. Thanks in advance, Thomas.