sp_iqshowcompression procedure

Function

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

Syntax

sp_iqshowcompression ( owner, 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-2: 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

Example 2

For this example, assume the following 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 the sp_iqshowcompression procedure using the following command (you must have DBA permission):

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

This command returns one row:

'picJPG','ON'