sp_iqsetcompression procedure

Sets compression of data in columns of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data types.

sp_iqsetcompression ( owner, table, column, on_off_flag )

Requires DBA authority.

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.

For this example, 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.