Neoview Guide to Stored Procedures in Java (R2.2)

,first_name CHARACTER (15)
DEFAULT ' '
NOT NULL
,last_name CHARACTER (20)
DEFAULT ' '
NOT NULL
,deptnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,jobcode NUMERIC (4) UNSIGNED
DEFAULT NULL
,salary NUMERIC (8, 2) UNSIGNED
DEFAULT NULL
,PRIMARY KEY (empnum)
);
ALTER TABLE persnl.employee
ADD CONSTRAINT empnum_constrnt
CHECK (empnum BETWEEN 0001 AND 9999);
CREATE INDEX xempname
ON employee (
last_name
,first_name
);
CREATE INDEX xempdept
ON employee (
deptnum
);
CREATE VIEW persnl.emplist
AS SELECT
empnum
,first_name
,last_name
,deptnum
,jobcode
FROM employee;
INSERT INTO persnl.employee
VALUES ( 1,'ROGER' ,'GREEN' ,9000, 100,175500.00 ),
( 23,'JERRY' ,'HOWARD' ,1000, 100,137000.10 ),
( 29,'JANE' ,'RAYMOND' ,3000, 100,136000.00 ),
( 32,'THOMAS' ,'RUDLOFF' ,2000, 100,138000.40 ),
( 39,'KLAUS ' ,'SAFFERT' ,3200, 100, 75000.00 ),
( 43,'PAUL' ,'WINTER' ,3100, 100, 90000.00 ),
( 65,'RACHEL' ,'MCKAY' ,4000, 100,118000.00 ),
( 72,'GLENN' ,'THOMAS' ,3300, 100, 80000.00 ),
( 75,'TIM' ,'WALKER' ,3000, 300, 32000.00 ),
( 87,'ERIC' ,'BROWN' ,4000, 400, 89000.00 ),
( 89,'PETER' ,'SMITH' ,3300, 300, 37000.40 ),
( 93,'DONALD' ,'TAYLOR' ,3100, 300, 33000.00 ),
( 104,'DAVID' ,'STRAND' ,4000, 400, 69000.00 ),
( 109,'STEVE' ,'COOK' ,4000, 400, 68000.00 ),
( 111,'SHERRIE' ,'WONG' ,3500, 100, 70000.00 ),
( 178,'JOHN' ,'CHOU' ,3500, 900, 28000.00 ),
( 180,'MANFRED' ,'CONRAD' ,4000, 450, 32000.00 ),
( 201,'JIM' ,'HERMAN' ,3000, 300, 19000.00 ),
( 202,'LARRY' ,'CLARK' ,1000, 500, 25000.75 ),
108 Sample Database