COMPRESS

Description

Specifies that system default values are to be stored using minimal space.

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

COMPRESS SYSTEM DEFAULT is removed because it is not applicable in Snowflake

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10) COMPRESS SYSTEM DEFAULT
);

Snowflake

Code

CREATE TABLE T1
(
COL1 VARCHAR(10)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--                 COMPRESS SYSTEM DEFAULT
);

Known issues

There are no known issues.