SQL/MX Programming Manual for Java

Sample Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
C-5
SQLJ Source File
#sql [ctx1] {ALTER TABLE employee_internatl
ADD CONSTRAINT empnum_constrnt
CHECK (empnum BETWEEN 0001 and 9999) };
System.out.println(
"A constraint was added to the EMPLOYEE_INTERNATL table.");
#sql [ctx1] {CREATE INDEX xempname_internatl
ON employee_internatl (
last_name,
first_name
) };
#sql [ctx1] {CREATE INDEX xempdept_internatl
ON employee_internatl ( deptnum ) };
System.out.println(
"Indexes were created on the EMPLOYEE_INTERNATL table.");
#sql [ctx1] {CREATE VIEW emplist_internatl
AS SELECT
empnum,
first_name,
last_name,
deptnum,
jobcode
FROM employee_internatl };
System.out.println("The EMPLIST_INTERNATL view was created.");
#sql [ctx1] {CREATE TABLE dept_internatl
( deptnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Dept/Num'
,deptname CHARACTER (12) CHARACTER SET UCS2
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Dept/Name'
,manager NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Mgr'
,rptdept NUMERIC (4) UNSIGNED
DEFAULT 0
NOT NULL NOT DROPPABLE
HEADING 'Rpt/Dept'
,location VARCHAR (18) CHARACTER SET UCS2
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Location'
,PRIMARY KEY (deptnum) NOT DROPPABLE
)
};
System.out.println("The DEPT_INTERNATL table was created.");
#sql [ctx1] {ALTER TABLE dept_internatl
ADD CONSTRAINT mgrnum_constrnt
CHECK (manager BETWEEN 0000 and 9999) };
Example C-1. SampleDDL.sqlj—Creating Tables From an SQLJ
Program (page 4 of 7)