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

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-7
ORDERS Table
,city CHARACTER (14)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'City'
,state CHARACTER (12)
DEFAULT 0
NOT NULL NOT DROPPABLE
HEADING
'State'
,postcode CHARACTER (10)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Post Code'
,credit CHARACTER (2)
DEFAULT
'C1'
NOT NULL NOT DROPPABLE
HEADING
'CR'
,PRIMARY KEY (custnum) NOT DROPPABLE
);
This statement creates the XCUSTNAM index:
CREATE INDEX xcustnam
ON customer (
custname
);
This statement creates the CUSTLIST view:
CREATE VIEW custlist
AS SELECT
custnum
,custname
,street
,city
,state
,postcode
FROM customer;
ORDERS Table
This statement creates the ORDERS table:
CREATE TABLE samdbcat.sales.orders
( ordernum NUMERIC (6) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Order/Num'
,order_date DATE
DEFAULT DATE '2002-07-01'
NOT NULL NOT DROPPABLE
HEADING
'Order/Date'