$FILL_DBMS_FIELDS

Fill DBMS fields in the same way as a record-level connector.

$FILL_DBMS_FIELDS

Defaults

Assignment file: server assignment files
Section: [SETTINGS]
Default value: None

Description

$FILL_DBMS_FIELDS causes fields written to a field-level DBMS connector (such as Sybase or Oracle) to be treated like fields written to a record-level connector, that is, character fields are filled with spaces (a Null value is never stored) and binary, raw, and image fields are set to zero:

  • When an occurrence is inserted, all fields of the occurrence are filled in this manner. For Numeric, Floating, and Boolean fields, a 0 is stored when the field is empty.
  • When an occurrence is updated, only fields in the field list are updated.

In a Uniface Server environment, this assignment should appear in the server assignment file.