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

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-10
SUPPLIER Table
This statement creates the XPARTDES index:
CREATE INDEX xpartdes
ON parts (
partdesc
);
SUPPLIER Table
This statement creates the SUPPLIER table:
CREATE TABLE samdbcat.invent.supplier
( suppnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Supp/Num'
,suppname CHARACTER (18)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Supplier Name'
,street CHARACTER (22)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Street'
,city CHARACTER (14)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'City'
,state CHARACTER (12)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'State'
,postcode CHARACTER (10)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Post Code'
,PRIMARY KEY (suppnum) NOT DROPPABLE
);
This statement creates the XSUPPNAM index:
CREATE INDEX xsuppnam
ON supplier (
suppname
);