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

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-9
ODETAIL Table
ODETAIL Table
This statement creates the ODETAIL table:
CREATE TABLE samdbcat.sales.odetail
( ordernum NUMERIC (6) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Order/Num'
,partnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Part/Num'
,unit_price NUMERIC (8, 2)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Unit/Price'
,qty_ordered NUMERIC (5) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Qty/Ord'
,PRIMARY KEY (ordernum,partnum) NOT DROPPABLE
);
PARTS Table
This statement creates the PARTS table:
CREATE TABLE samdbcat.sales.parts
( partnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Part/Num'
,partdesc CHARACTER (18)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Part Description'
,price NUMERIC (8, 2)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Price'
,qty_available NUMERIC (5)
DEFAULT 0
NOT NULL NOT DROPPABLE
HEADING
'Qty/Avail'
,PRIMARY KEY (partnum) NOT DROPPABLE
);