Data Definition Language (DDL) Reference Manual (G06.24+)

Definition Attributes
Data Definition Language (DDL) Reference Manual—426798-002
6-50
TYPE Clause
start-date-time and end-date-time must each be one of the following:
YEAR
MONTH
DAY
HOUR
MINUTE
SECOND
FRACTION [ end-field-precision ]
The start-date-time item must appear earlier in this list than the end-
date-time item. For example, SQL INTERVAL DAY TO MINUTE is a valid
SQL INTERVAL specification, but SQL INTERVAL MINUTE TO DAY is not
valid.
start-date-time and end-date-time must both be in either of the
following groups: YEAR and MONTH; or DAY, HOUR, MINUTE, SECOND, and
FRACTION. For example, SQL INTERVAL YEAR TO MONTH is a valid SQL
INTERVAL specification, but SQL INTERVAL MONTH TO HOUR is not valid.
start-field-precision is an unsigned integer that specifies the number
of significant digits for the starting field. The default value is 2.
FRACTION specifies the maximum number of digits for a fraction of a second.
The valid range for end-field-precision is 1 through 6. The default value
is 6.
BIT
represents the bit maps of the item.
bit-length
specifies the size of the bit fields; bit-length is an integer from 1 to 15.
ENUM enum-name
specifies the enumeration definition that contains the values to use for the
BIT item. The definition must be in the open dictionary, and the
enumeration values in the definition must fit within the number of bits
specified for the item, excluding any sign bit.
def-name
refers to a data structure previously entered into the dictionary by a DEFINITION
statement with the specified def-name.
*
refers to a data structure previously entered into the dictionary by a DEFINITION
statement with the same def-name as the referring structure.