VMS Help  —  SQL72  System Tables, RDB$FIELD_SUB_TYPE
    The following table lists the values for the RDB$FIELD_SUB_TYPE
    and the RDB$PARAMETER_SUB_TYPE columns.

                     RDB$FIELD_TYPE = DSC$K_DTYPE_ADT

    RDB$FIELD_SUB_TYPE [1]      Summary Description

    Less than 0                 Reserved for future use.
    Equal to 0                  Traditional OpenVMS timestamp, which
                                includes year, month, day, hour,
                                minute, second.
    7                           DATE ANSI, which includes year,
                                month, day.
    56                          TIME, which includes hour, minute,
                                second.
    63                          TIMESTAMP, which includes year,
                                month, day, hour, minute, second.
    513                         INTERVAL YEAR.
    514                         INTERVAL MONTH.
    515                         INTERVAL YEAR TO MONTH.
    516                         INTERVAL DAY.
    520                         INTERVAL HOUR.
    524                         INTERVAL DAY TO HOUR.
    528                         INTERVAL MINUTE.
    536                         INTERVAL HOUR TO MINUTE.
    540                         INTERVAL DAY TO MINUTE.
    544                         INTERVAL SECOND.
    560                         INTERVAL MINUTE TO SECOND.
    568                         INTERVAL HOUR TO SECOND.
    572                         INTERVAL DAY TO SECOND.

             RDB$FIELD_TYPE = DSC$K_DTYPE_T or DSC$K_DTYPE_VT

    RDB$FIELD_SUB_TYPE          Summary Description

    Equal to 0                  ASCII or DEC_MCS character set.
    Greater than 0              Character set other than ASCII or
                                DEC_MCS.
    Less than 0                 Special use of character data.

                  RDB$FIELD_TYPE = DSC$K_DTYPE_BLOB [2]

    RDB$FIELD_SUB_TYPE          Summary Description

    Less than 0                 User-specified.
    Equal to 0                  Default.
    Equal to 1                  BLR (query) type.
    Equal to 2                  Character type.
    Equal to 3                  MBLR (definition) type.
    Equal to 4                  Binary type.
    Equal to 5                  OBLR (outline) type.
    Greater than 5              Reserved for future use.

    Footnotes:
    [1]   When RDB$FIELD_SUB_TYPE is not equal to 0, then
          RDB$SEGMENT_LENGTH can hold the interval leading field
          precision for intervals, and RDB$FIELD_SCALE can hold
          the fractional seconds precision for interval, time, or
          timestamp.
    [2]   RDB$SEGMENT_LENGTH is the suggested size for a single
          binary large object (BLOB) segment.
Close Help