record size
Specify the maximum record size.
USYS$Mnemonic_PARAMS =
record size: Number
USYS$Mnemonic_PARAMS =
recsize: Number
Arguments
Number—number in the range 1 through 8000. If not specified, the DBMS maximum row length is chosen.
Use
|
Applies to |
Mnemonic |
Connector Syntax |
|---|---|---|
|
Microsoft SQL Server |
MSS |
|
|
ODBC connector |
ODx |
|
Description
Use the record size option to specify the maximum record size in number of bytes.
Microsoft SQL Server
When changing the record size, the table definitions change to use the new record size. The record size cannot be changed on the fly. Existing data must be migrated.
When using the Uniface overflow tables, this is true for both the main table and the overflow table. The fixed part of the record is still 8000 bytes to stay compatible with older Uniface versions. Values above 8000 will be ignored.
When using nls, the limits are 4000 and 10 MB.
