SQL/MX Programming Manual for Java

Sample Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
C-6
SQLJ Source File
#sql [ctx1] {ALTER TABLE dept_internatl
ADD CONSTRAINT deptnum_constrnt
CHECK (deptnum IN (
1000,
1500,
2000,
2500,
3000,
3100,
3200,
3300,
3500,
4000,
4100,
9000 )) };
System.out.println(
"Constraints were added to the DEPT_INTERNATL table.");
#sql [ctx1] {CREATE INDEX xdeptmgr_internatl
ON dept_internatl ( manager ) };
#sql [ctx1] {CREATE INDEX xdeptrpt_internatl
ON dept_internatl ( rptdept ) };
System.out.println("Indexes were created on the DEPT_INTERNATL table.");
#sql [ctx1] {CREATE VIEW mgrlist_internatl (
first_name,
last_name,
department
)
AS SELECT
first_name,
last_name,
deptname
FROM dept_internatl, employee_internatl
WHERE dept_internatl.manager = employee_internatl.empnum
};
System.out.println("The MGRLIST_INTERNATL view was created.");
#sql [ctx1] {CREATE TABLE job_internatl
( jobcode NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Job/Code'
,jobdesc VARCHAR (18) CHARACTER SET UCS2
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Job Description'
,PRIMARY KEY (jobcode) NOT DROPPABLE
)
};
System.out.println("The JOB_INTERNATL table was created.");
Example C-1. SampleDDL.sqlj—Creating Tables From an SQLJ
Program (page 5 of 7)