Codasyl DBMS Data Types

CONNX Data Type

SQL Data Type

Length

VMS Equivalent Data Type

Description

Binary

CHAR

8

This date should not be used. It is here for backward compatibility. See VMS DATE/Time.

This converts a VMS date into a 23-character string.

Binary (Text)

CHAR

-1

Double

DOUBLE

8

VMS Double Real
Maxcim Double Real

Double precision floating point (8 bytes).

Left Separate -> Decimal

DECIMAL

-1

Left Separate -> Double

DOUBLE

1-20

Left Separate

Left Separate Double

Left Separate -> Integer

LONG

1-20

Left Separate

Left Separate Integer

Longword

INTEGER

4

Longword -> Decimal

DECIMAL

4

VMS Longword Integer with implied decimal

PIC S9(X1)V9(X2) COMP
where X1+X2 is between 5 and 9.

Longword Integer with an implied decimal place (4 bytes).

Longword -> Double

DOUBLE

4

Quadword -> Char

VARCHAR

8

Quadword -> Char(DP)

VARCHAR

8

Quadword Decimal

CHAR

8

VMS Quadword Integer with implied decimal

PIC S9(X1)V9(X2) COMP

where X1+X2 is between 10 and 20.

Quadword Integer with an implied decimal place (8 bytes) converts to a SQL String.

Signed Overpunch -> Decimal

DECIMAL

-1

Signed Overpunch -> Double

DOUBLE

-1

Single

REAL

4

VMS Single Real
Maxcim Single Real

Single precision floating point (4 bytes).

Text (Expandable)

VARCHAR

1-30000

Alphanumeric and symbols. (1-30000 chars).

Text (Right Space Padded)

CHAR

1-30000

Text

Maxcim Yes/No

Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding.

VMS Date/Time

TIMESTAMP

8

VMS Binary Date/Time (8 Bytes) converts to an ODBC Timestamp.

VMS Double -> Currency

DECIMAL

8

VMS G Float

DOUBLE

8

Word

SMALLINT

2

Word -> Float

REAL

2

Word Double (2)

DOUBLE

2

Word converted to double with implied decimal point.

Word Numeric -> Decimal

DECIMAL

2