Compression Options

Description

Specifies whether row compression is to be used for the table.

Click here to navigate to the IBM DB2 docs page for this syntax.

The Compression Options are not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

CREATE TABLE T1 (
COl1 INT,
COL2 INT
) 
COMPRESS YES
;


CREATE TABLE T1 (
COl1 INT,
COL2 INT
) 
COMPRESS YES ADAPTIVE
;

CREATE TABLE T1 (
COl1 INT,
COL2 INT
) 
COMPRESS YES STATIC
;


CREATE TABLE T1 (
COl1 INT,
COL2 INT
) 
COMPRESS NO
;


CREATE TABLE T1 (
COl1 INT,
COL2 INT
) 
VALUE COMPRESSION
;

Snowflake

Code 1

CREATE TABLE PUBLIC.T1 (
COl1 INT,
COL2 INT
)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--COMPRESS YES
;


CREATE TABLE PUBLIC.T1 (
COl1 INT,
COL2 INT
)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--COMPRESS YES ADAPTIVE
;

CREATE TABLE PUBLIC.T1 (
COl1 INT,
COL2 INT
)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--COMPRESS YES STATIC
;


CREATE TABLE PUBLIC.T1 (
COl1 INT,
COL2 INT
)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--COMPRESS NO
;


CREATE TABLE PUBLIC.T1 (
COl1 INT,
COL2 INT
)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--VALUE COMPRESSION
;

Related EWIs

1. MSCEWI1002: REMOVED STATEMENT, NOT APPLICABLE IN SNOWFLAKE.