DMSII and Relational Database Data Types

The DBEngine retrieves the requested DMSII data, and DBServer passes the data to the DATABridge Client, where it is assigned to standard relational database data types.

The following table lists equivalent data types for DMSII, Microsoft SQL Server, Oracle and DB2.

DMSII Data Type	SQL Server	Oracle	DB2
ALPHA (<= char_limit bytes)	CHAR *	CHAR †	CHAR
ALPHA (>char_limit bytes)	TEXT	VARCHAR2	VARCHAR
ALPHA (>varchar2_limit_bytes)	TEXT	CLOB	N/A
BOOLEAN	BIT	NUMBER(1)	SMALLINT
FIELD: FIELD(n) where n is < 16 FIELD(n) where n is < 32 FIELD(n) where n >= 32	SMALLINT INT BIGINT ‡	NUMBER(5) NUMBER(10) NUMBER(10–15)	SMALLINT INT DECIMAL(10-15)
NUMERIC:
NUMBER(n) where n is a DMSII declared length <= 2 NUMBER(n) where n is a DMSII declared length <= 4 NUMBER(n) where n is a DMSII declared length <= 9 NUMBER(n) where n is a DMSII declared length <= 15 NUMBER(n) where n is a DMSII declared length >15 NUMBER(n,m) where n is a DMSII declared length and m is the number of places after the decimal point.	TINYINT § SMALLINT INT BIGINT ‡ DEC(n) DEC(n,m)	NUMBER(n) NUMBER(n) NUMBER(n) NUMBER(n) NUMBER(n) NUMBER(n,m)	SMALLINT SMALLINT SMALLINT DECIMAL (n) DECIMAL (n) DECIMAL (n, m)
REAL:
REAL(n) where n is a DMSII declared length <= 2 REAL(n) where n is a DMSII declared length <= 4 REAL(n) where n is a DMSII declared length <= 9 REAL(n) where n is a DMSII declared length > 9 REAL(n,m) where n is the DMSII declared length and m is the number of places after the decimal point. REAL, with no precision or scale	TINYINT § SMALLINT INT DEC DEC(n,m) FLOAT	NUMBER(n) NUMBER(n) NUMBER(n) NUMBER(n) NUMBER(n,m) FLOAT	SMALLINT SMALLINT INT INT DECIMAL FLOAT
Date encoding methods (For information, see Decoding DMSII Dates, Times, and Date/Times.	DATETIME SMALLDATETIME DATE (SQL 2008) DATETIME2 (SQL 2008)	DATE	TIMESTAMP

* VARCHAR if the configuration parameter use_varchar is set to True.

† VARCHAR2 if the configuration parameter use_varchar is set to True.

‡ If the configuration parameter use_bigint is set to False, DEC(n) will be used instead.

§ Note that if the number is signed, SMALLINT is used instead. TINYINT is an unsigned quantity in SQL Server.