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

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual—426798-002
D-26
DICTOBL Fields
•
NULL-VALUE−the ASCII value used by DDL when producing FUP source output
for an alternate key.
•
NULL-VALUE-OBJECT−if the null value is defined by a constant, contains the
object number of the constant; otherwise, it is 0.
•
SPI-NULL-VALUE−contains a user-specified SPI null value used by SPI to process
token maps.
•
SPI-NULL-VALUE-OBJECT−if the SPI null value is defined by a constant, contains
the object number of the constant; otherwise, it is 0.
•
NULL-VALUE-SPECIFIED−contains the ASCII character Y (yes) to indicate this
item has a null value or N (no) to indicate it does not. The default for this field is N.
•
SPI-NULL-VALUE-SPECIFIED−contains the ASCII character Y (yes) to indicate a
SPI null value was explicitly specified for this object or N (no) to indicate it was not.
The default for this field is N.
•
UPSHIFT−contains the ASCII character Y (yes) to indicate this data item is to be
upshifted or N (no) to indicate it is not to be upshifted.
Only an elementary item can be upshifted. The field must be declared as
alphabetic or alphanumeric. The default for this field is N.
•
USER-DEFINED-FILLER−contains the ASCII character Y (yes) to indicate this field
is a user-defined FILLER field or N (no) to indicate it is not. The default for this field
is N.
•
PADDED-FILLER−contains the ASCII character Y (yes) to indicate that an SQL
VARCHAR element has an odd byte length and has an OCCURS clause
associated with it; contains N (no) to indicate that the element does not. The
default for this field is N.
•
GROUP-COMP−for group items; contains the ASCII character Y (yes) to indicate
the group is defined as computational or N (no) to indicate it is not. All elementary
items within a group defined as computational are treated as though they were
individually defined as computational. The default for this field is N.
•
SOURCE-DEF-FLAG−contains the ASCII character Y (yes) to indicate this item is
defined with TYPE * or TYPE def-name or N (no) to indicate it is not. The default
for this field is N.
•
NOVALUE−contains the ASCII character Y (yes) or N (no) to indicate whether this
item has the NOVALUE attribute. NOVALUE suppresses any VALUE IS clause in a
referenced definition. NOVALUE can be specified only for a field or group definition
defined with a TYPE clause. The default for this field is N.
•
TACL-INHERITED−contains the ASCII character Y (yes) to indicate the TACL type
was inherited from a definition or N (no) to indicate the type was explicitly
specified.