sp_iqshowcompression procedure

Function

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

Syntax

sp_iqshowcompressionowner, table, column )

Permissions

Requires DBA authority.

Description

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

Table 5-5: 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

Example

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'