SQL Programming Manual for TAL

Sample NonStop SQL Database
HP NonStop SQL Programming Manual for TAL—527887-001
A-2
For more information about SQLCI, see the SQL/MP Version Management Guide.
Figure A-1. Sample NonStop SQL Database Relations
VSTA01.vsd
One to one
One to many
*
The PARTLOC table is
partitioned by the value
of LOC_CODE.
Legend
partnum
suppnum
partcost
qty_received
errors_date
errors_time
errors_id
errors_sql
errors_text 1
errors_text 2
suppnum
suppname
street
city
state
postcode
loc_code
partnum
qty_on_hand
custnum
custname
street
city
state
postcode
credit
ordernum
order_date
deliv_date
salesrep
custnum
ordernum
partnum
unit_price
qty_ordered
partnum
partdesc
price
qty_available
deptnum
deptname
manager
rptdept
location
jobcode
jobdesc
empnum
first_name
last_name
deptnum
jobcode
salary