SnowConvert AI - IBM DB2 - Data Types¶
Description¶
Specifies the data type of the column
Click here (https://www.ibm.com/docs/en/db2/11.5?topic=statements-create-table#sdx-synid_built-in-type)to navigate to the IBM DB2 docs page for this syntax.
Transformations¶
The following table shows the transformation from Db2 to Snowflake.
| Db2 | Snowflake | EWI |
|---|---|---|
| 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 | SSC-EWI-0036 |
| BOOLEAN | BOOLEAN |
Sample Source Patterns¶
IBM DB2¶
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¶
CREATE TABLE T1
(
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 !!!RESOLVE EWI!!! /*** SSC-EWI-0036 - XMLTYPE DATA TYPE CONVERTED TO VARIANT ***/!!!,
COL42 BOOLEAN
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "db2", "convertedOn": "08/29/2025", "domain": "no-domain-provided" }}';