* 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)
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.