Remarks
sp_iqsetcompression provides control of
compression of LONG BINARY
(BLOB) and LONG
VARCHAR (CLOB) data type
columns. The compression setting applies only to
base tables.
A side effect of sp_iqsetcompression is
that a COMMIT occurs after you change the compression
setting.
sp_iqsetcompression parametersName
|
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
|
on_off_flag
|
Compression setting: ON enables compression,
OFF disables compression
|
Example
Assume this table definition:
CREATE TABLE USR.pixTable (picID INT NOT NULL,
picJPG LONG BINARY NOT NULL);
To turn off compression on the LOB column picJPG, call sp_iqsetcompression:
CALL sp_iqsetcompression('USR', 'pixTable', 'picJPG',
'OFF') ;
This command returns no rows.