String search functions for large object columns [CR 415543]

Sybase IQ 12.7 ESD #3 provides string search capabilities on large objects. Sybase IQ now includes support of string search functions for LONG VARCHAR (CLOB) and LONG BINARY (BLOB) data. The string search functions CHARINDEX and LOCATE have been enhanced to allow a LONG VARCHAR or a LONG BINARY column as the argument for the string expression to be searched and now return a 64 bit value for the position of the string in the LONG VARCHAR or LONG BINARY column.

The PATINDEX function has been enhanced to allow a LONG VARCHAR column as the argument for the string expression to be searched and now returns a 64 bit value for the position of the string in the LONG VARCHAR column.

For the descriptions of the enhanced string search functions that will be added to Chapter 4, “Function Support” of Large Objects Management in Sybase IQ, see “String search functions for large object columns [CR 415543]”.

The first sentence in the section “LONG BINARY columns in queries” in Chapter 2, “Binary Large Object (BLOB) data” will be modified to say:

“In WHERE clauses of the SELECT statement, LONG BINARY columns can only be used in IS NULL and IS NOT NULL expressions, in addition to the BYTE_LENGTH64, BYTE_SUBSTR64, BYTE_SUBSTR, BIT_LENGTH, OCTET_LENGTH, CHARINDEX, and LOCATE functions.”

The first sentence in the section “LONG VARCHAR columns in queries” in Chapter 3, “Character Large Object (CLOB) data” will be modified to say:

“In WHERE clauses of the SELECT statement, LONG VARCHAR columns can only be used in IS NULL and IS NOT NULL expressions, in addition to the BIT_LENGTH, OCTET_LENGTH, CHAR_LENGTH, CHAR_LENGTH64, SUBSTRING64, SUBSTRING, CHARINDEX, LOCATE, and PATINDEX functions.”