![Result data type of a REPLACE function [CR 417507]](arrow-left.gif){kind=icon}
![New database option WD_DELETE_METHOD [CR 415547]](arrow-right.gif){kind=icon}
Sybase IQ 12.7 ESD #3 provides support for WORD (WD) indexes on LONG VARCHAR character large object (CLOB) columns and support of the CONTAINS predicate on LONG VARCHAR (CLOB) columns with a WD index.
The following sentence will be added to the “Description” section of the “sp_iqrebuildindex procedure” section in Chapter 10, “System Procedures”:
“sp_iqrebuildindex will rebuild a WD index on a column of data type LONG VARCHAR (CLOB).”
The first sentence following the syntax in the “CONTAINS conditions” section in the “Search conditions” section in Chapter 3, “SQL Language Elements” will be changed to say:
“The column-name must be either a CHAR, VARCHAR, or LONG VARCHAR (CLOB) column in a base table and must have a WD index.”
The following sentence will be added to the “Data types” section under “Notes” in the “CREATE INDEX statement” section in Chapter 6, “SQL Statements”:
Only the default and WD index types can be created on LONG VARCHAR data.
