sp_iqshowcompression Procedure

Displays compression settings for columns of LONG BINARY (BLOB) and LONG VARCHAR (CLOB) data types.

Syntax

sp_iqshowcompression ( owner, table, column )

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

Returns the column name and compression setting. Compression setting values are 'ON' (compression enabled) and 'OFF' (compression disabled).

sp_iqshowcompression 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

Assume this table definition:

CREATE TABLE USR.pixTable (picID INT NOT NULL,
picJPG LONG BINARY NOT NULL);

To check the compression status of the columns in the pixTable table, call sp_iqshowcompression:

CALL sp_iqshowcompression('USR', 'pixTable',
'picJPG') ;

This command returns one row:

'picJPG','ON'