B.6 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                  VARBINARY(n) (if SIZE < 255)
  directive             IMAGE (if SIZE > 255)
VAR-LENGTH              VARCHAR(n) (if SIZE < 255)
  directive
Usage FLOAT             REAL (if SIZE = 4)
Usage DOUBLE            FLOAT (if SIZE = 8)

Any other numeric usage:
PIC 9(n)                SMALLINT (if n < 5)
                        INT (if n > 5 and < 10)

PIC 9(n)V9(m)           DECIMAL(n,m) 
                        FLOAT (if n > 10)
                        SMALLMONEY
                          (if n < 6 and m < 5)
                        MONEY (if n > 6 and < 15,
                           and m < 5)
                        FLOAT (if n > 15)

Any other usage:
PIC X(n)                CHAR(n) (if n < 255)
                        TEXT (if n > 255)

Other limits are described in Appendix B of the ACUCOBOL-GT compiler manual.