SQL/MP Programming Manual for COBOL

SQL/MP Sample Database
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
A-2
Figure A-1 shows the names of columns and tables and the relations between the
tables in the sample database.
Figure A-1. SQL/MP Sample Database Relations
custnum
custname
street
city
state
postcode
credit
CUSTOMER Table
errors_date
errors_time
errors_id
errors_sql
errors_text 1
errors_text 2
ERRORS Table
ordernum
partnum
unit_price
qty_ordered
ODETAIL Table
PERSNL
Subvolume
SALES
Subvolume
INVENT
Subvolume
PARTSUPP Table
partnum
suppnum
partcost
qty_received
PARTLOC Table *
loc_code
partnum
qty_on_hand
PARTS Table
partnum
partdesc
price
qty_available
EMPLOYEE Table
empnum
first_name
last_name
deptnum
jobcode
salary
JOB Table
jobcode
jobdesc
ORDERS Table
ordernum
order_date
deliv_date
salesrep
custnum
Legend
The PARTLOC table can
be partitioned by the
value of LOC_CODE.
*
One to one
One to many
SUPPLIER Table
suppnum
suppname
street
city
state
postcode
SUPPKANJ Table
suppnum
suppname_kanji
suppname_katakana
suppname_english
street
city
state
postcode
DEPT Table
deptnum
deptname
manager
rptdept
location
VST007.vsd