Dictionary Database Structure
Data Definition Language (DDL) Reference Manual — 426798-002
D -25
DICTOBL Fields
•
SCALE-the scale factor in a numeric field; the scale is equal to the number of
positions to the right of the implied decimal point.
•
OFFSET
−
the number of bytes from the first byte of the object to the first byte of
this element; byte numbering begins with 0.
•
OCCURS-MIN
−
the minimum number of times LOCAL-NAME occurs; the default
value is 1.
If the element is described by an OCCURS min TO max TIMES DEPENDING ON
clause, this field contains the value of min.
•
OCCURS-MAX
−
the number of times LOCAL-NAME occurs; the default value is 1.
If the element is described by an OCCURS max TIMES clause, this field contains
the value max.
•
OCCURS-MIN-OBJECT
−
if min is defined as a constant, contains the object
number of the constant; otherwise, it is 0.
•
OCCURS-MAX-OBJECT
−
if max is defined by a constant, contains the object
number of the constant; otherwise, it is 0.
•
OCCURS-ELEMENT
−
the element number of the field in an OCCURS
DEPENDING ON field-name clause. This element must be defined as an integer. If
there is no DEPENDING ON clause, the field is set to 0.
•
STARTING
−
the first element of the set of elements renamed by a level 66
RENAMES clause, where this starting element has the same offset as renaming
element.
•
ENDING
−
the last element of the set of elements renamed by a level 66 RENAMES
clause, where this ending element ends at the same position as the renaming
element.
•
TALBOUND
−
contains a binary value that specifies the lower limit of pTAL or TAL
arrays. Valid values are 0 and 1. The default value for this field is 1.
70
SQL INTERVAL MINUTE TO SECOND
6
71
SQL INTERVAL HOUR TO SECOND
9
72
SQL INTERVAL DAY TO SECOND
12
73
SQL INTERVAL FRACTION
7
74
SQL INTERVAL SECOND TO FRACTION
10
75
SQL INTERVAL MINUTE TO FRACTION
13
76
SQL INTERVAL HOUR TO FRACTION
16
77
SQL INTERVAL DAY TO FRACTION
19
Table D-5. SQL INTERVAL Element Sizes (page 2 of 2)
Code Meaning
Element
Содержание 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 ...