sp_iqshowcompression Procedure

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

Syntax

sp_iqshowcompression ( owner, table, column )

You must have EXECUTE privilege on the system procedure. You must also have one of the following system privileges:

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'