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.