LOB OPTIONS

Description

Options for the LOB (Large Object Binary) data types

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

LOB OPTIONS are removed because they are not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10) LOGGED,
COL2 VARCHAR(10) NOT LOGGED,
COL3 VARCHAR(10) COMPACT,
COL4 VARCHAR(10) NOT COMPACT
)

Snowflake

Code

CREATE OR REPLACE TABLE T1
(
COL1 VARCHAR(10) -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--  LOGGED
,
COL2 VARCHAR(10) -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--  NOT LOGGED
,
COL3 VARCHAR(10) -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--  COMPACT
,
COL4 VARCHAR(10) -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--  NOT COMPACT
)

Known issues

There are no known issues.