HP 3000 Manuals HP 3000 Manuals
Appendix G Element and File Dictionary Reports
The following reports from DICTDBM list the elements and file definitions
for the database and files used in the examples throughout this manual.
Figure G-1 graphically portrays the relationship of the datasets and data
items.
> report element
LIST OF DATA ELEMENTS DEFINED IN THE DICTIONARY
ELEMENT(PRIMARY): TYPE: SIZE: DEC: LENGTH: COUNT:
BACK-ORDER I 6 0 4 1
CITY-STATE X 20 0 20 1
CUST-NO 9 4 0 4 1
DESCRIPTION X 20 0 20 1
LINE-NO 9 2 0 2 1
LOCATION X 4 0 4 1
NAME X 20 0 20 1
ORDER-DATE X 6 0 6 1
ORDER-NO X 8 0 8 1
ORDER-STATUS X 2 0 2 1
PART-NUMBER X 8 0 8 1
QUANTITY I 6 0 4 1
STREET-ADDR X 20 0 20 1
ZIPCODE X 6 0 6 1
> show file
FILE orders
SHOW ALL FILE ELEMENTS(Y/N)?> y
FILE TYPE: RESPONSIBILITY:
ORDERS BASE
FILE(ALIAS): TYPE: FILE(PRIMARY): CAPACITY:
CUSTOMER MAST CUSTOMER 100
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
CUST-NO * 9 (4,0,4) CUST-NO
NAME X (20,0,20) NAME
STREET-ADDR X (20,0,20) STREET-ADDR
CITY-STATE X (20,0,20) CITY-STATE
ZIPCODE X (6,0,6) ZIPCODE
FILE(ALIAS): TYPE: FILE(PRIMARY): CAPACITY:
ORDER AUTO ORDER 100
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
ORDER-NO * X (8,0,8) ORDER-NO
FILE(ALIAS): TYPE: FILE(PRIMARY): CAPACITY:
PARTS MAST PARTS 100
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
PART-NUMBER * X (8,0,8) PART-NUMBER
DESCRIPTION X (20,0,20) DESCRIPTION
FILE(ALIAS): TYPE: FILE(PRIMARY): CAPACITY:
ORDERHEAD DETL ORDERHEAD 100
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
ORDER-NO * X (8,0,8) ORDER-NO
CHAIN MASTER SET: ORDER
CUST-NO * 9 (4,0,4) CUST-NO
CHAIN MASTER SET: CUSTOMER
ORDER-STATUS X (2,0,2) ORDER-STATUS
ORDER-DATE X (6,0,6) ORDER-DATE
FILE(ALIAS): TYPE: FILE(PRIMARY): CAPACITY:
ORDERLINE DETL ORDERLINE 100
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
ORDER-NO * X (8,0,8) ORDER-NO
CHAIN MASTER SET: ORDER
LINE-NO 9 (2,0,2) LINE-NO
PART-NUMBER * X (8,0,8) PART-NUMBER
CHAIN MASTER SET: PARTS
QUANTITY I (6,0,4) QUANTITY
FILE(ALIAS): TYPE: FILE(PRIMARY): CAPACITY:
INVENTORY DETL INVENTORY 100
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
PART-NUMBER * X (8,0,8) PART-NUMBER
CHAIN MASTER SET: PARTS
LOCATION X (4,0,4) LOCATION
QUANTITY I (6,0,4) QUANTITY
> show file
FILE kcust
PRIMARY/SECONDARY (P/S)?>
FILE TYPE: RESPONSIBILITY:
KCUST KSAM
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
CUST-NO ! 9 (4,0,4) CUST-NO
NAME * X (20,0,20) NAME
> show file
FILE shortage
PRIMARY/SECONDARY (P/S)?>
FILE TYPE: RESPONSIBILITY:
SHORTAGE MPEF
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
CUST-NO 9 (4,0,4) CUST-NO
PART-NUMBER X (8,0,8) PART-NUMBER
ORDER-NO X (8,0,8) ORDER-NO
ORDER-DATE X (6,0,6) ORDER-DATE
LINE-NO 9 (2,0,2) LINE-NO
QUANTITY I (6,0,4) QUANTITY
BACK-ORDER I (6,0,4) BACK-ORDER
> show file
FILE batchinv
PRIMARY/SECONDARY (P/S)?>
FILE TYPE: RESPONSIBILITY:
BATCHINV MPEF
ELEMENT(ALIAS): PROPERTIES: ELEMENT(PRIMARY):
PART-NUMBER X (8,0,8) PART-NUMBER
LOCATION X (4,0,4) LOCATION
QUANTITY I (6,0,4) QUANTITY
_____________________________________________________________________________
| |
| IMAGE DATABASE = ORDERS |
| ---------------------------------------------- |
| --------------- -------------- --------------- |
| | MANUAL MASTER | | AUTO MASTER | | MANUAL MASTER | |
| | CUSTOMER | | ORDER | | PARTS | |
| --------------- ------------- --------------- |
| Cust-no --------- Order-no Part-number |
| -- Name | | ----- Description |
| | Street-addr | | | | Selling-Price |
| | City-state | | | | |
| | Zipcode | | | | |
| | | | | | |
| | ------------ | | ------------ | | ----------- |
| | | DETAIL SET | | | | DETAIL SET | | | | DETAIL SET| |
| | | ORDERHEAD | | | | ORDERLINE | | | | INVENTORY | |
| | ------------ | | ------------ | | ----------- |
| | *Order-no | | *Order-no | | *Part-number |
| |-- *Cust-no --- ------ Line-no ---- |----- Location |
| Order-status *Part-number Quantity |
| Order-date Quantity |
| |
| |
| MPE FILES KSAM FILE|
| ---------------------------- |
| ---------- ---------- ------- |
| | SHORTAGE | | BATCHINV | | KCUST | |
| ---------- ---------- ------- |
| Cust-no Part-number *Cust-no |
| Part-no Location *Name |
| Order-date |
| Line-no |
| Quantity |
| Back-order |
_____________________________________________________________________________
Figure G-1. The database and files used throughout this document