Cannot Use Index Type in RLV Enabled Table

Problem: You either receive the error message "The index type 'TEXT' cannot be used with an RLV enabled table", or "The index type 'WD' cannot be used with an RLV enabled table".

Explanation

The use of text indexes and word indexes within a row-level versioning (RLV) enabled table are not supported in the current version of SAP Sybase IQ. You cannot create these indexes on a table enabled for row-level versioning. Furthermore, you can not enable row-level versioning on a table which has a text or word index.