Limits and Ranges

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

The following limits exist when working with MSSQL:

Maximum number of columns per key:	16
Maximum number of columns:	1024
Maximum number of bytes in a single row when using Database Connectors for MSSQL:	8060

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

Database Connectors 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 XFD directive	DATETIME
BINARY XFD directive	VARBINARY(`n`) (if SIZE < 255) IMAGE (if SIZE >255)
VAR_LENGTH XFD 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) or NCHAR(n) (if n < 255)
(Note: NCHAR columns are dependent on the variable A_MSSQL_CREATE_UNICODE_COLUMNS set to TRUE)
TEXT (if n > 255)

Note: If the VAR_LENGTH XFD directive is in effect, VARCHAR and NVARCHAR types are created instead.