B.6.3 Acu4GL for Microsoft SQL Server: Limits and Ranges

The following limits exist for the Microsoft SQL Server file system:

Maximum number of columns per key: 16
Maximum number of columns: 250

To achieve the same sort or retrieval sequence under Microsoft SQL Server as under the Vision file system, key fields that contain signed numeric data must be preceded by a BINARY directive.

Acu4GL for Microsoft SQL Server supports the data types shown below; when it's creating tables, the following conversion rules are used, in the sequence shown:

COBOL SQL Server
DATE directive
DATETIME
BINARY directive
VARBINARY(n) (if SIZE < 255) IMAGE (if SIZE > 255)
VAR_LENGTH directive
VARCHAR(n) (if SIZE < 255)
Usage FLOAT
REAL (if SIZE = 4)
Usage DOUBLE
FLOAT (if SIZE = 8)

Any other numeric usage:

PIC 9(n)V9(m)
SMALLINT (if m = 0 and n < 5) INT (if m = 0 and n < 10) DECIMAL(n + m, m)(otherwise)

Any other usage:

PIC X(n)
CHAR(n) (if n < 255) TEXT (if n > 255)

Other limits are described in Appendix B in Book 4 of the ACUCOBOL-GT documentation set.

COBOL	SQL Server
`DATE directive`	`DATETIME`
`BINARY directive`	`VARBINARY(n) (if SIZE < 255) IMAGE (if SIZE > 255)`
`VAR_LENGTH directive`	`VARCHAR(n) (if SIZE < 255)`
`Usage FLOAT`	`REAL (if SIZE = 4)`
`Usage DOUBLE`	`FLOAT (if SIZE = 8)`