E.6.3 Limits and Ranges

The following limits exist for the Sybase file system:

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

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

Acu4GL for Sybase supports the data types shown below. When it's creating tables, the following conversion rules are used, in the sequence shown:

COBOL
SYBASE
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) 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.

COBOL	SYBASE
`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) FLOAT (if SIZE = 8)`