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.