Sets compression of data in columns of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data types.
sp_iqsetcompression provides control of compression of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data type columns. The compression setting applies only to Sybase IQ base tables.
A side effect of sp_iqsetcompression is that a COMMIT occurs after you change the compression setting.
Assume this table definition:
CREATE TABLE USR.pixTable (picID INT NOT NULL, picJPG LONG BINARY NOT NULL);
To turn off compression on the LOB column picJPG, call sp_iqsetcompression (you must have DBA permission):
CALL sp_iqsetcompression('USR', 'pixTable', 'picJPG', 'OFF') ;
This command returns no rows.