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

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-5
JOB Table
CHECK (deptnum IN (
1000
,1500
,2000
,2500
,3000
,3100
,3200
,3300
,3500
,4000
,4100
,9000
));
This statement creates the XDEPTMGR index:
CREATE INDEX xdeptmgr
ON dept (
manager
);
This statement creates the XDEPTRPT index:
CREATE INDEX xdeptrpt
ON dept (
rptdept
);
This statement creates the MGRLIST view:
CREATE VIEW mgrlist (
first_name
,last_name
,department
)
AS SELECT
first_name
,last_name
,deptname
FROM
dept
,employee
WHERE
dept.manager = employee.empnum;
JOB Table
This statement creates the JOB table:
CREATE TABLE samdbcat.persnl.job
( jobcode NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Job/Code'