Data Definition Language (DDL) Reference Manual

Introduction to DDL
Data Definition Language (DDL) Reference Manual—529431-004
1-7
Creating a Database
Creating a Database
You use DDL RECORD statements to define database files. If you specify a FUP
command in a schema file or interactively, the DDL compiler opens a FUP file,
translates each subsequent RECORD statement to FUP file creation commands, and
writes the commands to the open FUP file.
The FUP command file is an EDIT file. If you want to add to the FUP commands
generated by the DDL compiler, you can close the FUP file and then modify it with a
text editor. For example, you can create a partitioned file by adding the PART
parameter to the FUP code. For information on file attributes that you cannot specify in
DDL, see the File Utility Program (FUP) Reference Manual.
When you finish editing the file creation commands, you can run the FUP program
using the FUP command file as the input file. FUP creates the files according to the file
attributes originally specified in the DDL RECORD statements. For a full description of
Figure 1-2. Creating a Dictionary
PS TEXT EDIT
DDL
Source
Schema
Dictionary
Schema
Listing
10> TEDIT schema
DEF. . .
.
.
.
RECORD. . .
.
.
11> DDL / IN schema / DICT
or
11> DDL DICT
!?OUT $S.#printer
!?SOURCE schema
!EXIT
1
2
Build schema in EDIT file
Compile schema and create dictionary
VST002.vsd