sp_iqsetcompression Procedure

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

Syntax

sp_iqsetcompression ( owner, table, column, on_off_flag )

Permissions

ALTER ANY TABLE or ALTER ANY OBJECT system privilege required or own table.

Description

sp_iqsetcompression provides control of compression of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data type columns. The compression setting applies only to base tables.

A side effect of sp_iqsetcompression is that a COMMIT occurs after you change the compression setting.

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

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:

CALL sp_iqsetcompression('USR', 'pixTable', 'picJPG',
'OFF') ;

This command returns no rows.