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(8) COMP-5. 32-bit signed integer
SMALLINT 01 name PIC S9(3) COMP-5. 16-bit signed integer
VARCHAR(n)* 01 name.

49 name-length PIC s9(4)


49 name-name PIC X(n).

Variable-length character string (n <= 4000)

* To be treated as a VARCHAR, the elementary items in a group item consisting of only a numeric item and a character item need to be level 49 as in the following:

01 my-record.
   49 my-number 	pic s9(3) comp-5.
   49 my-name 			pic x(20).