2.3.4 Access Data Type Compatibility

The following table describes data type compatibility for Microsoft Access and AcuSQL.

SQL Type	COBOL Type	Description
CHAR (n)	01 name PIC X(n).	Fixed-length character string
DOUBLE PRECISION	01 name USAGE IS DOUBLE.	Double-precision floating point
INTEGER	01 name PIC s9(n) COMP-5.	32-bit signed integer
SMALLINT	01 name PIC s9(n) COMP-5.	16-bit signed integer
VARCHAR(n)	01 name. 05 name-length PIC s9(4) COMP-5. 05 name-name PIC X(n).	Variable-length character string (n <= 4000)
DATETIME	01 name PIC X(24)	8 character string