HP 3000 Manuals HP 3000 Manuals
Appendix B Entering the Database Definition
The following is an example of entering database and file definitions
into the dictionary. The IMAGE database ORDERS, KSAM file KCUST, and MPE
files BATCHINV and SHORTAGE which are all used by the examples of this
manual, are the definitions entered by this example. The example is also
complete, that is it completely defines the files and database.
The example shows the minimum data that must be added. The other data,
such as heading text, entry text, and edit masks, when entered helps to
customize the application.
:file dict.pub=dict
:run dictdbm.pub.sys
DICTIONARY/3000 HP32244A.02.00 - (C) Hewlett-Packard Co. 1983
PASSWORD FOR DICT.PUB>
FORMS ENTRY(Y/N)?>
> repeat create file
FILE orders
LONG NAME
TYPE base
RESPONSIBILITY
DESCRIPTION
FILE customer
LONG NAME
TYPE mast
RESPONSIBILITY
DESCRIPTION
FILE order
LONG NAME
TYPE auto
RESPONSIBILITY
DESCRIPTION
FILE parts
LONG NAME
TYPE mast
RESPONSIBILITY
DESCRIPTION
FILE orderhead
LONG NAME
TYPE detl
RESPONSIBILITY
DESCRIPTION
FILE orderline
LONG NAME
TYPE detl
RESPONSIBILITY
DESCRIPTION
FILE inventory
LONG NAME
TYPE detl
RESPONSIBILITY
DESCRIPTION
FILE kcust
LONG NAME
TYPE ksam
RESPONSIBILITY
DESCRIPTION
ADDITIONAL FILE ATTRIBUTES(N/Y)?>
FILE batchinv
LONG NAME
TYPE mpef
RESPONSIBILITY
DESCRIPTION
ADDITIONAL FILE ATTRIBUTES(N/Y)?>
FILE shortage
LONG NAME
TYPE mpef
RESPONSIBILITY
DESCRIPTION
ADDITIONAL FILE ATTRIBUTES(N/Y)?>
FILE
> relate file
PARENT FILE orders
CHILD FILE customer
CHILD ALIAS
CAPACITY 100
BLOCKMAX
DESCRIPTION
CHILD FILE order
CHILD ALIAS
CAPACITY 100
BLOCKMAX
DESCRIPTION
CHILD FILE parts
CHILD ALIAS
CAPACITY 100
BLOCKMAX
DESCRIPTION
CHILD FILE orderhead
CHILD ALIAS
CAPACITY 100
BLOCKMAX
DESCRIPTION
CHILD FILE orderline
CHILD ALIAS
CAPACITY 100
BLOCKMAX
DESCRIPTION
CHILD FILE inventory
CHILD ALIAS
CAPACITY 100
BLOCKMAX
DESCRIPTION
CHILD FILE
> repeat create element
ELEMENT cust-no
LONG NAME
TYPE 9
SIZE 4
DECIMAL
STORAGE LENGTH(4)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
BLANK WHEN ZERO(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT name
LONG NAME
TYPE x
SIZE 20
STORAGE LENGTH(20)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT street-addr
LONG NAME
TYPE x
SIZE 20
STORAGE LENGTH(20)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT city-state
LONG NAME
TYPE x
SIZE 20
STORAGE LENGTH(20)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT zipcode
LONG NAME
TYPE x
SIZE 6
STORAGE LENGTH(6)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT order-no
LONG NAME
TYPE x
SIZE 8
STORAGE LENGTH(8)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT order-status
LONG NAME
TYPE x
SIZE 2
STORAGE LENGTH(2)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT order-date
LONG NAME
TYPE x
SIZE 6
STORAGE LENGTH(2)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT line-no
LONG NAME
TYPE 9
SIZE 2
DECIMAL
STORAGE LENGTH(2)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
BLANK WHEN ZERO(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT quantity
LONG NAME
TYPE i
SIZE 6
DECIMAL
STORAGE LENGTH(4)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
SYNCHRONIZED(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT part-number
LONG NAME
TYPE x
SIZE 8
STORAGE LENGTH(8)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT description
LONG NAME
TYPE x
SIZE 20
STORAGE LENGTH(20)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT location
LONG NAME
TYPE x
SIZE 4
STORAGE LENGTH(4)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT back-order
LONG NAME
TYPE i
SIZE 6
STORAGE LENGTH(4)
COUNT(1)
HEADING TEXT
ENTRY TEXT
EDIT MASK
MEASUREMENT UNITS
RIGHT JUSTIFY(N/Y)?>
RESPONSIBILITY
DESCRIPTION
ELEMENT
> repeat add file
FILE order
KEY ELEMENT order-no
ELEMENT ALIAS
DESCRIPTION
FILE customer
KEY ELEMENT cust-no
ELEMENT ALIAS
DESCRIPTION
ELEMENT name
ELEMENT ALIAS
DESCRIPTION
ELEMENT street-addr
ELEMENT ALIAS
DESCRIPTION
ELEMENT city-state
ELEMENT ALIAS
DESCRIPTION
ELEMENT zipcode
ELEMENT ALIAS
DESCRIPTION
ELEMENT
FILE parts
KEY ELEMENT part-number
ELEMENT ALIAS
DESCRIPTION
ELEMENT description
ELEMENT ALIAS
DESCRIPTION
ELEMENT
FILE orderhead
ELEMENT order-no
ELEMENT ALIAS
PATH MASTER FILE order
SORT ELEMENT
PRIMARY PATH(N/Y)?>
DESCRIPTION
ELEMENT cust-no
ELEMENT ALIAS
PATH MASTER FILE customer
SORT ELEMENT
PRIMARY PATH(N/Y)?>
DESCRIPTION
ELEMENT order-status
ELEMENT ALIAS
PATH MASTER FILE
DESCRIPTION
ELEMENT order-date
ELEMENT ALIAS
PATH MASTER FILE
DESCRIPTION
ELEMENT
FILE orderline
ELEMENT order-no
ELEMENT ALIAS
PATH MASTER FILE order
SORT ELEMENT
PRIMARY PATH(N/Y)?>
DESCRIPTION
ELEMENT line-no
ELEMENT ALIAS
PATH MASTER FILE
DESCRIPTION
ELEMENT part-number
ELEMENT ALIAS
PATH MASTER FILE parts
SORT ELEMENT
PRIMARY PATH(N/Y)?>
DESCRIPTION
ELEMENT quantity
ELEMENT ALIAS
PATH MASTER FILE
DESCRIPTION
ELEMENT
FILE inventory
ELEMENT part-number
ELEMENT ALIAS
PATH MASTER FILE parts
SORT ELEMENT
PRIMARY PATH(N/Y)?>
DESCRIPTION
ELEMENT location
ELEMENT ALIAS
PATH MASTER FILE
DESCRIPTION
ELEMENT quantity
ELEMENT ALIAS
PATH MASTER FILE
DESCRIPTION
ELEMENT
FILE shortage
PRIMARY/SECONDARY (P/S)?>
ELEMENT cust-no
ELEMENT ALIAS
DESCRIPTION
ELEMENT part-number
ELEMENT ALIAS
DESCRIPTION
ELEMENT order-no
ELEMENT ALIAS
DESCRIPTION
ELEMENT order-date
ELEMENT ALIAS
DESCRIPTION
ELEMENT line-no
ELEMENT ALIAS
DESCRIPTION
ELEMENT quantity
ELEMENT ALIAS
DESCRIPTION
ELEMENT back-order
ELEMENT ALIAS
DESCRIPTION
ELEMENT
FILE batchinv
PRIMARY/SECONDARY (P/S)?>
ELEMENT part-number
ELEMENT ALIAS
DESCRIPTION
ELEMENT location
ELEMENT ALIAS
DESCRIPTION
ELEMENT quantity
ELEMENT ALIAS
DESCRIPTION
ELEMENT
FILE kcust
PRIMARY/SECONDARY (P/S)?>
ELEMENT cust-no
ELEMENT ALIAS
KEY ELEMENT(N/Y)?> y
PRIMARY KEY(N/Y)?> y
DUPLICATES (N/Y)?> n
DESCRIPTION
ELEMENT name
ELEMENT ALIAS
KEY ELEMENT(N/Y)?> y
DUPLICATES (N/Y)?> y
DESCRIPTION
ELEMENT
FILE
>exit
END OF PROGRAM