DDL Compiler Commands
Data Definition Language (DDL) Reference Manual — 426798-002
9- 43
DDL Command
•
The specified DDL source file must be an EDIT file, an unstructured file, or a
sequential device such as a terminal, a spooler, or a process. If the file exists but is
not one of these types, DDL issues an error message and does not open the file.
•
Each DDL object translated into DDL source is written to the source file in a
separate section that has the same name as the DDL structure it contains. You can
suppress the individual section headings with the SETSECTION compiler
command.
•
For dictionaries created from the DDL compiler, the DDL source is almost identical
to the original source schema at the time the dictionary was created, and can be
used to rebuild a dictionary.
DDL Command Examples
If the file \DALLAS.$DATA.SALES.DDLSRC already exists, the exclamation point in the
following example directs the DDL compiler to purge the contents of the file before
opening it. If the file does not exist, DDL creates a new file with the specified name.
?DDL \dallas.$data.sales.ddlsrc !
In the next example, the compiler writes all the definitions and records from an open
dictionary to the DDL source file, DDLSRC, first purging any data in that file. Assume
that the dictionary does not contain Pathmaker information.
Suppose the dictionary contains one record, CUSTOMER, and all definitions
necessary to build that record. DDLSRC would contain this code:
?Section NAME
Definition NAME.
02 LAST-NAME Pic "X(12)"
UPSHIFT.
02 FIRST-NAME Pic "X(8)"
UPSHIFT.
02 MIDINIT Pic "X(2)"
UPSHIFT.
End
?Section ADDR
Definition ADDR.
02 ADDRESS Pic "X(22)".
02 CITY Pic "X(14)".
02 STATE Pic "X(2)".
Caution. Do not attempt to rebuild a dictionary installed by the Pathmaker product from DDL
source code; Pathmaker application design information will be lost.
29> DDL
!?DICT $data.sales
!?DDL ddlsrc !
!OUTPUT *.
!EXIT
Open existing dictionary
Clear and open DDL source file
Write all definitions and records to DDL
source file
VST907.vsd
Содержание 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 ...