sp_iqsetcompression procedure

Function

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

Syntax

sp_iqsetcompressionowner, table, column, on_off_flag )

Permissions

Requires DBA authority.

Description

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.

Table 5-4: sp_iqsetcompression parameters

Name

Description

owner

Owner of the table for which you are setting compression

table

Table for which you are setting compression

column

Column for which you are setting compression

on_off_flag

Compression setting: ON enables compression, OFF disables compression

Example

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.