The following table describes data type compatibility for 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 |