disable segmented fields

Disable BLOB support. Map fields with segmented interface into the variable portion of the record.

USYS$ORA_PARAMS = disable segmented fields

USYS$ORA_PARAMS = dsf

Description

Map fields with segmented interface into the variable portion of the record.

You can use this option in the following situations:

  • If a table contains more than one Long or Long Raw column because you have defined one or more segmented fields in your modeled entities.

    Oracle does not allow more than one Long or Long Raw column per table. If you specify use of the Uniface variable-length technique (using overflow tables), you avoid this problem because only one Long or Long Raw column is necessary per table.

  • If memory limitations specific to your operating system stop your application from writing a large segmented field.

    If you specify using the Uniface variable-length technique, the connector is no longer dependent on operating-system dynamic memory allocation when writing a field with a segmented interface.

Caution: When you store fields in the database using the Uniface variable-length technique, they can only be accessed by Uniface.