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

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-8
DATE_CONSTRNT Constraint
,deliv_date DATE
DEFAULT DATE '2002-08-01'
NOT NULL NOT DROPPABLE
HEADING
'Deliv/Date'
,salesrep NUMERIC (4) UNSIGNED
DEFAULT 0
NOT NULL NOT DROPPABLE
HEADING
'Sales/Rep'
,custnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Cust/Num'
,PRIMARY KEY (ordernum) NOT DROPPABLE
);
DATE_CONSTRNT Constraint
This statement creates the DATE_CONSTRNT constraint:
ALTER TABLE orders
ADD CONSTRAINT date_constrnt
CHECK (deliv_date >= order_date);
This statement creates the XORDREP index:
CREATE INDEX xordrep
ON orders (
salesrep
);
This statement creates the XORDCUS index:
CREATE INDEX xordcus
ON orders (
custnum
);
This statement creates the ORDREP view:
CREATE VIEW ordrep
AS SELECT empnum
,last_name
,ordernum
,o.custnum
FROM
samdbcat.persnl.employee e
,samdbcat.sales.orders o
,samdbcat.sales.customer c
WHERE
e.empnum = o.salesrep
AND
o.custnum = C.custnum;