The following limits exist for the MSSQL file system:
| Maximum number of columns per key: |
16 |
| Maximum number of columns: |
250 |
| Maximum number of bytes in a single row when using Database Connectors for MSSQL: |
1962 |
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) (if n < 255)
TEXT (if n > 255)
|
