The specially licensed Large Objects Management option has been extended to include support of Character Large Object (CLOB) data, in addition to Binary Large Object (BLOB) data.
In addition to the functions added to support BLOB data, BYTE_LENGTH64, BYTE_SUBSTR64, and BYTE_SUBSTR, four new functions support CLOB data: BIT_LENGTH, OCTET_LENGTH, CHAR_LENGTH64, and SUBSTRING64. The BIT_LENGTH and OCTET_LENGTH functions support all data types.
The IQ data extraction facility has been enhanced with the new BFILE function, which allows you to extract individual BLOB and CLOB cells to individual operating system files on the server. BFILE can also be used without the data extraction facility.
For information on the Large Objects Management option, see Large Objects Management in Sybase IQ, which is included in the Sybase IQ documentation set.
To install this feature, you must enter a license key provided in Sybase IQ Large Objects Management Option Installation Key, a paper document you receive when you purchase the Large Objects Management option.
