row limit
Set the limit for the number of bytes in the fixed-length portion of a record.
USYS$SYB_PARAMS = row limitRowSize
Arguments
RowSize—number of bytes in the fixed-length portion of a record; an integer greater than or equal to 1800
Description
Uniface uses this byte alignment when determining the size of a row, although Sybase does
not. Therefore, when the row limit connector option is used, users must take
into account the extra bytes required by Uniface for alignment and use a row limit
which is larger than the actual Sybase DBMS limit.
For example, if the table has a Char(4) and a Float field, Uniface requires 16 bytes, although only 12 bytes are required in the actual physical row stored in the DBMS. Users must take into account the extra bytes for Uniface alignment when setting the row limit connector option.
The table lists the alignment required for the various data types:
|
Data Type |
Alignment on Byte |
|---|---|
|
Binary |
none |
|
Char |
none |
|
Datetime |
4 |
|
Float |
8 |
|
Identity |
none |
|
Integer |
4 |
|
Money |
8 |
|
Numeric |
none |
|
Real |
4 |
|
Smalldatetime |
4 |
|
Smallint |
2 |
|
Smallmoney |
4 |
|
Tinyint |
none |
|
Varchar |
none |
|
Varbinary |
none |
