RDOHELP72.HLB  —  Segment str, More
    Because Oracle Rdb does not know what kind of data is contained in
    a segmented string, you cannot perform many of the standard data
    manipulation functions on it. You cannot use logical operators,
    such as EQ and CONTAINING, to compare segmented strings. Oracle Rdb
    does not perform any data type conversion on data that is
    transferred into or out of a segmented string. You can use the
    MISSING operator on a segmented string field.

    Oracle Rdb defines a special name to refer to the segments of a
    segmented string. This name is equivalent to a field name;
    it names the "fields" or segments of the string. Furthermore,
    because segments can vary in length, Oracle Rdb also defines a name
    for the length of a segment. You must use these names in the
    value expressions that you use to retrieve the length and value
    of a segment. These names are:

    RDB$VALUE          The value stored in a segment of a segmented
                       string
    RDB$LENGTH         The length in bytes of a segment

    Because a single segmented string field value is made up of
    multiple segments, you must manipulate the segments one at a
    time. Therefore, segmented string operations require an internal
    looping mechanism, much like the record stream set up by a FOR or
    START_STREAM statement.
Close Help