Dictionary Database Structure
Data Definition Language (DDL) Reference Manual — 426798-002
D- 3
Dictionary Files
Table D-1
shows the text items described in the following three objects:
CONSTANT custnum-heading VALUE "Customer".
DEF initials PIC XXX VALUE ALL SPACES
HELP "Initials".
DEF quantity PIC 999 MUST BE 1 THRU 999.
In
Table D-1
, each text item is assigned a unique text ID number. Note that a single
text item can contain more than one text type.
Dictionary Files
When DDL compiles a source schema into a dictionary, it builds 14 files.
Table D-2
lists
the names of these files with a brief description of each file. All the files except
DICTDDF are key-sequenced; DICTDDF is an unstructured file.
Table D-1. Text IDs Assigned to Text Items
Text ID
Element Number
Text Item
Type
1
0
“Customer”
S (String)
2
0
“XXX”
S (String)
3
0
“ALL”
K (Keyword)
3
1
“SPACES”
K (Keyword)
4
0
“Initials”
S (String)
5
0
“999”
S (String)
6
0
“1”
N (Number)
6
1
“THRU”
K (Keyword)
6
2
“999”
N (Number)
Table D-2. Dictionary Files Built for a Source Schema (page 1 of 2)
Name
Description
DICTALT
ALTERNATE KEY FILE—contains keys for DICTKDF, DICTOBL,
DICTODF, and DICTRDF.
DICTCDF
CONSTANT DEFINITION FILE—contains one CDF record for each
constant. Each record associates a constant name with the numeric or
string text in the DICTOTF (Object Text File) for that constant.
DICTDDF
DICTIONARY DEFINITION FILE—contains one DDF record with the
next object number to be assigned, the next text ID number to be
assigned, DDL version information, and the creator’s user ID.
DICTKDF
KEY DEFINITION FILE—contains one KDF record for each alternate or
primary key of each RECORD. DICTKDF also contains records
describing fields or groups sorted by a SEQUENCE IS clause.
Содержание 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 ...