sp_iqshowcompression procedure

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

sp_iqshowcompression ( owner, table, column )

Requires DBA authority.

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

For this example, 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 (you must have DBA permission):

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

This command returns one row:

'picJPG','ON'