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.
Содержание DDL D40
Страница 36: ...Introduction to DDL Data Definition Language DDL Reference Manual 426798 002 1 14 Examining a Dictionary ...
Страница 66: ...Named Constants Data Definition Language DDL Reference Manual 426798 002 4 10 Standard SPI Constants ...
Страница 230: ...Dictionary Manipulation Statements Data Definition Language DDL Reference Manual 426798 002 8 14 SHOW USE OF Statement ...
Страница 370: ...Dictionary Maintenance Data Definition Language DDL Reference Manual 426798 002 10 24 Converting a Dictionary ...
Страница 456: ...Sample Schemas Data Definition Language DDL Reference Manual 426798 002 B 12 ASSNDDL Statements ...
Страница 470: ...DDL Data Translation Data Definition Language DDL Reference Manual 426798 002 C 14 ...
Страница 528: ...Dictionary Reports Data Definition Language DDL Reference Manual 426798 002 E 8 Requesting Reports ...
Страница 552: ...DDL Alignment Rules Data Definition Language DDL Reference Manual 426798 002 H 4 FIELDALIGN_SHARED8 Alignment Rules ...
Страница 576: ...Index Data Definition Language DDL Reference Manual 426798 002 Index 22 Special Characters ...