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) COMP-5. 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).