HP 3000 Manuals HP 3000 Manuals
Appendix D Creating the Physical Database
If the IMAGE database has not been created, then after entering in the
database definition to the dictionary as shown in appendix B, this
definition is used by DICTDBC to create the IMAGE root file for the
database.
The example below shows the physical creation process for the database
ORDERS, KSAM file KCUST, and MPE files SHORTAGE and BATCHINV. These are
the database and files used by the examples throgshout the manual.
:run dictdbc.pub.sys
DICTIONARY/3000 DB CREATOR HP32244A.02.00 - (C) Hewlett-Packard Co. 1983
DICTIONARY PASSWORD>
BASE> orders
CONTROL LINE> nolist
SCHEMA FILE>
LISTING FILE>
APPLY SECURITY JUST TO SET LEVEL(N/Y)?>
SCHEMA GENERATION
DBSCHEMA PROCESSOR
PAGE 1 HEWLETT-PACKARD 32215B.03.10 IMAGE/3000: DBSCHEMA
THU, OCT 18, 1984, 2:27 PM (C) HEWLETT-PACKARD CO. 1978
$CONTROL NOLIST
DATA SET TYPE FLD PT ENTR MED CAPACITY BLK BLK DISC
NAME CNT CT LGTH REC FAC LGTH SPACE
CUSTOMER M 5 1 35 45 100 11 496 44
PARTS M 2 2 14 29 100 13 378 27
ORDER A 1 2 4 19 100 20 382 18
ORDERHEAD D 3 2 7 15 100 25 377 15
ORDERLINE D 4 2 11 19 100 20 382 18
INVENTORY D 3 1 8 12 120 40 483 16
TOTAL DISC SECTORS INCLUDING ROOT: 149
NUMBER OF ERROR MESSAGES: 0
ITEM NAME COUNT: 13 DATA SET COUNT: 6
ROOT LENGTH: 585 BUFFER LENGTH: 496 TRAILER LENGTH: 256
ROOT FILE ORDERS CREATED.
END OF PROGRAM
:run dbutil.pub.sys
HP32215B.03.10 IMAGE/3000: DBUTIL (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1978
>>cre orders
data base ORDERS has been CREATED.
>>exit
END OF PROGRAM
:build shortage;rec=-36,,,ascii;disc=100
:build batchinv;rec=-16,,,ascii;disc=100
:run ksamutil.pub.sys
>build kcust;rec=-24,,,ascii;keyfile=keycust > ;key=numeric,1,4 > ;key=byte,5,20,,duplicate
KCUST.group.acct & KEYCUST ARE CREATED.
>exit
END OF PROGRAM
: