# JDBC to DB2 mappings.

BIT = NUMERIC(1)
TINYINT =
SMALLINT = SMALLINT
INTEGER = INTEGER
BIGINT = BIGINT
FLOAT = FLOAT
REAL = REAL
DOUBLE = DOUBLE
NUMERIC = NUMERIC
DECIMAL = DECIMAL
CHAR = VARCHAR
VARCHAR = VARCHAR
LONGVARCHAR = LONG VARCHAR
DATE = DATE
TIME = TIME
TIMESTAMP = TIMESTAMP
BINARY = CHAR(n) FOR BIT DATA 
# For DB2/400, VARBINARY must be changed to VARCHAR (32000) FOR BIT DATA
VARBINARY = VARCHAR(n) FOR BIT DATA 
LONGVARBINARY = LONG VARCHAR FOR BIT DATA
NULL = NULL
OTHER =
JAVA_OBJECT =
DISTINCT = DISTINCT
STRUCT =
ARRAY =
BLOB = BLOB
CLOB = CLOB
REF =

AUTOINCREMENT = GENERATED ALWAYS AS IDENTITY
NOTNULL = NOT NULL