Filter
Top Products
DDL example Schema DDL
114 U929-J-Z125-9-76
A rough selection of articles is possible by means of the criteria ARTICLE-TYPE and
ARTICLE-SELECTION. This selection leads to a detailed article description. An article
description can comprise several articles differing in color, size and price.
The sets CONTAINS and CONTAINED-IN comprise a parts list used for parts supply.
In the ARTICLE records, colors are coded by numbers, materials in by abbreviations with
percentages. The record types COLOR and MATERIALS contain the assignments of the
codes to the associated meanings.
In the example, the schema is designed to provide as full an understanding of DDL clauses
as possible.
1 SCHEMA NAME IS MAIL-ORDERS
2 PRIVACY LOCK FOR COPY IS "SHIP-KEY".
3 *
4 *
5 *
6 AREA NAME IS CUSTOMER-ORDER-RLM.
7 AREA NAME IS PURCHASE-ORDER-RLM.
8 AREA NAME IS CLOTHING.
9 AREA NAME IS HOUSEHOLD-GOODS.
10 AREA NAME IS SPORTS-ARTICLES.
11 AREA NAME IS FOOD.
12 AREA NAME IS LEISURE.
13 AREA NAME IS STATIONERY.
14 AREA NAME IS ARTICLE-RLM.
15 AREA NAME IS SEARCH-RLM
16 AREA IS TEMPORARY.
17 *
18 *
19 *
20 RECORD NAME IS CUSTOMER
21 LOCATION MODE IS DIRECT-LONG CUST-NO OF CUSTOMER
22 WITHIN CUSTOMER-ORDER-RLM.
23 *
24 01 CUST-NAME TYPE IS CHARACTER 30.
25 01 CUST-F-NAME TYPE IS CHARACTER 30.
26 01 CUST-NO TYPE IS DATABASE-KEY-LONG.
27 *
28 *
29 RECORD NAME IS CST-ORDERS
30 WITHIN CUSTOMER-ORDER-RLM.
31 *
32 01 ORD-NO PICTURE IS 9(4).
33 01 ORD-YEAR PICTURE IS 99.
34 01 ORD-MONTH PICTURE IS 99.
35 01 ORD-DAY PICTURE IS 99.
36 01 ORD-STATUS PICTURE IS X.