Limits and Ranges

The following limits exist for the Sybase file system:

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)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 Limits and Ranges of the ACUCOBOL-GT documentation.