SQL/MX 2.x Reference Manual (H06.04+)

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-13
PARTLOC Table
PARTLOC Table
When you install the sample database, you can choose to partition the PARTLOC. If
you do not specify partitions when you run setmxdb, the unpartitioned PARTLOC table
is created:
CREATE TABLE samdbcat.invent.partloc
( loc_code CHARACTER (3)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Loc/Code'
,partnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Part/Num'
,qty_on_hand NUMERIC (7)
DEFAULT 0
NOT NULL NOT DROPPABLE
HEADING
'Qty/On/Hand'
,PRIMARY KEY (loc_code,partnum) NOT DROPPABLE
);
If you specify partitions when you run setmxdb, this statement creates the partitioned
PARTLOC table:
CREATE TABLE samdbcat.invent.partloc
( loc_code CHARACTER (3)
NO DEFAULT
NOT NULL
HEADING 'Loc/Code'
,partnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
HEADING 'Part/Num'
,qty_on_hand NUMERIC (7)
DEFAULT 0
HEADING 'Qty/On/Hand'
,PRIMARY KEY (loc_code,partnum))
LOCATION $PART1VOL
PARTITION (ADD FIRST KEY 'P00'
LOCATION $PART2VOL
);