Data Definition Language (DDL) Reference Manual — 426798-002
B- 1
B
Sample Schemas
This appendix contains two schemas: one to define a database and the other to define
SPI tokens.
Sample Database Schema
.The sample database schema defines a database consisting of nine files. The
database files are defined in RECORD statements that refer to previous DEFINITION
statements for their record structures. Many of the individual and group fields within
each record also refer to previous DEFINITION statements. All DISPLAY and
HEADING values in DEFINITION statements are defined in previous CONSTANT
statements.
When DDL compiles this schema, DDL builds a dictionary and generates two source-
code files:
Host-Language Source Code
A COBOL85 program that accesses the database can use the COBOL source code in
COBSRC as its Data division. C, FORTRAN, Pascal, pTAL, TACL, and TAL source
code can also be generated for this schema. For C and TACL, DDL issues warning
messages when generating the source code. For C, two data items (PRICE and
PARTCOST) are described with PICTURE clauses that are not supported by C. For
TACL, three data items (INVENTORY, PRICE, and PARTCOST) are described with
unsupported PICTURE clauses. DDL generates compatible C and TACL data types for
these items.
For Pascal, pTAL, and TAL, there are data items that contain unsupported data types,
but these languages do not issue warning messages. For Pascal, PRICE and
PARTCOST are described with PICTURE clauses that are unsupported. For pTAL or
TAL, INVENTORY, PRICE, and PARTCOST are described with unsupported PICTURE
clauses.
For FORTRAN, DDL issues warning messages for all constants; constants are not
supported by FORTRAN. The constants that describe display, heading, and help
values are not used by the source code, so this causes no problems; the generated
source code will execute successfully.
FUPSRC
A FUP source file that contains the FUP commands to create
each file described in the schema.
The database is created only when FUP is executed with this
file as input.
COBSRC
A COBOL source file that contains COBOL85 data descriptions
for all the fields, groups, and records in the schema.
Содержание 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 ...