segmented fields
Specify whether segmented fields will be stored to large object data types.
USYS$Mnemonic_PARAMS =
segmented fields : enabled | disabled
USYS$Mnemonic_PARAMS =
blobs : on | off
Use
| Applies to | Mnemonic | Connector Syntax |
|---|---|---|
| DB2 connector | DB2 | USYS$DB2_PARAMS
|
| MS SQL connector | MSS | USYS$MSS_PARAMS
|
| MySQL connector | MQL | USYS$MQL_PARAMS
|
Description
If not specified, the default is
enabled (or on).
Note: The options segmented fields
and blobs are functionally identical. If both are specified, the last one
specified is used. For example, if you specify blobs:on, segmented fields:
disabled, this is equivalent to blobs:off.
DB2
This setting controls whether segmented fields
will be stored in a single Varchar field, or in BLOB fields
MSS and MQL
When enabled, maps all packing codes having a
prefix S (SC, SR, SU) to large object data types. This option defaults to on
(enabled). When disabled, Uniface uses the overflow tables.
