Data Type

Description

Specifies the data type of the column

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

Transformations

The following table shows the transformation from Db2 to Snowflake.

Db2	Snowflake
SMALLINT	SMALLINT
INTEGER	INTEGER
INT	INT
BIGINT	BIGINT
DECIMAL	DECIMAL
DEC	DEC
NUMERIC	NUMERIC
NUM	NUMERIC
FLOAT	FLOAT
REAL	REAL
DOUBLE	DOUBLE
DECFLOAT	VARCHAR
CHARACTER	CHARACTER
CHAR	CHAR
VARCHAR	VARCHAR
CHARACTER VARYING	CHARACTER VARYING
CHAR VARYING	CHAR VARYING
CLOB	VARCHAR
CHARACTER LARGE OBJECT	VARCHAR
CHAR LARGE OBJECT	VARCHAR
CLOB	VARCHAR
CHARACTER LARGE OBJECT	VARCHAR
CHAR LARGE OBJECT	VARCHAR
GRAPHIC	BINARY
VARGRAPHIC	BINARY
DBCLOB	VARCHAR
NCHAR	NCHAR
NATIONAL CHAR	NCHAR
NATIONAL CHARACTER	NCHAR
NVARCHAR	NVARCHAR
NCHAR VARYING	NCHAR VARYING
NATIONAL CHAR VARYING	NCHAR VARYING
NATIONAL CHARACTER VARYING	NCHAR VARYING
NCLOB	VARCHAR
NCHAR LARGE OBJECT	VARCHAR
NATIONAL CHARACTER LARGE OBJECT	VARCHAR
BINARY	BINARY
VARBINARY	VARBINARY
BINARY VARYING	BINARY VARYING
BLOB	BINARY
BINARY LARGE OBJECT	BINARY
DATE	DATE
TIME	TIME
TIMESTAMP	TIMESTAMP
XML	VARIANT
BOOLEAN	BOOLEAN

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
	COL1 SMALLINT,
	COL2 INTEGER,
	COL3 INT,
	COL4 BIGINT,
	COL55 DECIMAL,
	COl5 DECIMAL(5,0),
	COL66 DEC,
	COL6 DEC(5,0),
	COL77 NUMERIC,
	COL7 NUMERIC(5,0),
	COL88 NUM,
	COL8 NUM(5,0),
	COL9 FLOAT,
	COL10 FLOAT(53),
	COL11 REAL,
	COL12 DOUBLE,
	COL13 DOUBLE PRECISION,
	COL14 DECFLOAT(34),
	COL144 DECFLOAT,
	COL153 CHARACTER(8 OCTETS) FOR BIT DATA,
	COL163 CHAR(8 OCTETS) FOR BIT DATA,
	COL164 CHAR(8 OCTETS) CCSID ASCII,
	COL171 VARCHAR(8 OCTETS),
	COL172 VARCHAR(8) FOR BIT DATA,
	COL18 CHARACTER VARYING(8),
	COL180 CHARACTER VARYING(8) FOR BIT DATA,
	COL19 CHAR VARYING(8),
	COL199 CHAR VARYING(8) FOR BIT DATA,
	COL20 CLOB(1M),
	COL21 CHARACTER LARGE OBJECT(8K OCTETS),
	COL22 CHAR LARGE OBJECT,
	COL23 GRAPHIC(1),
	COL233 GRAPHIC(1 CODEUNITS16),
	COL234 GRAPHIC(1 CODEUNITS32),
	COL24 VARGRAPHIC(8 CODEUNITS16),
	COL25 DBCLOB(1M),
	COL255 DBCLOB(1K),
	COL26 NCHAR(1),
	COL27 NATIONAL CHAR(2),
	COL28 NATIONAL CHARACTER(3),
	COL29 NVARCHAR(8),
	COL30 NCHAR VARYING(8),
	COL31 NATIONAL CHAR VARYING(8),
	COL32 NATIONAL CHARACTER VARYING(8),
	COL333 NCLOB(1M),
	COL334 NCHAR LARGE OBJECT(5),
	COL335 NATIONAL CHARACTER LARGE OBJECT(1M),
	COL33 BINARY,
	COL34 VARBINARY(14),
	COL35 BINARY VARYING(10),
	COL36 BLOB(1M),
	COL37 BINARY LARGE OBJECT(1M),
	COL38 DATE,
	COL39 TIME,
	COL40 TIMESTAMP,
	COL41 XML,
	COL42 BOOLEAN
);

Snowflake

Code

CREATE TABLE PUBLIC.T1
(
	COL1 SMALLINT,
COL2 INTEGER,
COL3 INT,
COL4 BIGINT,
COL55 DECIMAL,
COl5 DECIMAL(5,0),
COL66 DEC,
COL6 DEC(5,0),
COL77 NUMERIC,
COL7 NUMERIC(5,0),
COL88 NUMERIC,
COL8 NUMERIC(5,0),
COL9 FLOAT,
COL10 FLOAT(53),
COL11 REAL,
COL12 DOUBLE,
COL13 DOUBLE PRECISION,
COL14 VARCHAR,
COL144 VARCHAR,
COL153 BINARY,
COL163 BINARY,
COL164 CHAR(8),
COL171 VARCHAR(8),
COL172 BINARY,
COL18 CHARACTER VARYING(8),
COL180 BINARY,
COL19 CHAR VARYING(8),
COL199 BINARY,
COL20 VARCHAR,
COL21 VARCHAR,
COL22 VARCHAR,
COL23 BINARY,
COL233 BINARY,
COL234 BINARY,
COL24 BINARY,
COL25 VARCHAR,
COL255 VARCHAR,
COL26 NCHAR(1),
COL27 NCHAR(2),
COL28 NCHAR(3),
COL29 NVARCHAR(8),
COL30 NCHAR VARYING(8),
COL31 NCHAR VARYING(8),
COL32 NCHAR VARYING(8),
COL333 VARCHAR,
COL334 VARCHAR,
COL335 VARCHAR,
COL33 BINARY,
COL34 VARBINARY(14),
COL35 BINARY VARYING(10),
COL36 BINARY,
COL37 BINARY,
COL38 DATE,
COL39 TIME,
COL40 TIMESTAMP,
COL41 VARIANT,
COL42 BOOLEAN
);