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

( 203,'KATHRYN' ,'HALL' ,4000, 400, 96000.00 ),
( 205,'GINNY' ,'FOSTER' ,3300, 900, 30000.00 ),
( 206,'DAVE' ,'FISHER' ,3200, 900, 25000.00 ),
( 207,'MARK' ,'FOLEY' ,4000, 420, 33000.00 ),
( 208,'SUE' ,'CRAMER' ,1000, 900, 19000.00 ),
( 209,'SUSAN' ,'CHAPMAN' ,1500, 900, 17000.00 ),
( 210,'RICHARD' ,'BARTON' ,1000, 500, 29000.00 ),
( 211,'JIMMY' ,'SCHNEIDER' ,1500, 600, 26000.00 ),
( 212,'JONATHAN','MITCHELL' ,1500, 600, 32000.00 ),
( 213,'ROBERT' ,'WHITE' ,1500, 100, 90000.00 ),
( 214,'JULIA' ,'KELLY' ,1000, 500, 50000.00 ),
( 215,'WALTER' ,'LANCASTER' ,4000, 450, 33000.50 ),
( 216,'JOHN' ,'JONES' ,4000, 450, 40000.00 ),
( 217,'MARLENE' ,'BONNY' ,4000, 900, 24000.90 ),
( 218,'GEORGE' ,'FRENCHMAN' ,4000, 420, 36000.00 ),
( 219,'DAVID' ,'TERRY' ,2000, 250, 27000.12 ),
( 220,'JOHN' ,'HUGHES' ,3200, 300, 33000.10 ),
( 221,'OTTO' ,'SCHNABL' ,3200, 300, 33000.00 ),
( 222,'MARTIN' ,'SCHAEFFER' ,3200, 300, 31000.00 ),
( 223,'HERBERT' ,'KARAJAN' ,3200, 300, 29000.00 ),
( 224,'MARIA' ,'JOSEF' ,4000, 420, 18000.10 ),
( 225,'KARL' ,'HELMSTED' ,4000, 450, 32000.00 ),
( 226,'HEIDI' ,'WEIGL' ,3200, 300, 22000.00 ),
( 227,'XAVIER' ,'SEDLEMEYER',3300, 300, 30000.00 ),
( 228,'PETE' ,'WELLINGTON',3100, 300, 32000.20 ),
( 229,'GEORGE' ,'STRICKER' ,3100, 300, 32222.00 ),
( 230,'ROCKY' ,'LEWIS' ,2000, 200, 24000.00 ),
( 231,'HERB' ,'ALBERT' ,3300, 300, 33000.00 ),
( 232,'THOMAS' ,'SPINNER' ,4000, 450, 45000.00 ),
( 233,'TED' ,'MCDONALD' ,2000, 250, 29000.00 ),
( 234,'MARY' ,'MILLER' ,2500, 100, 56000.00 ),
( 235,'MIRIAM' ,'KING' ,2500, 900, 18000.00 ),
( 321,'BILL' ,'WINN' ,2000, 900, 32000.00 ),
( 337,'DINAH' ,'CLARK' ,9000, 900, 37000.00 ),
( 343,'ALAN' ,'TERRY' ,3000, 900, 39500.00 ),
( 557,'BEN' ,'HENDERSON' ,4000, 400, 65000.00 ),
( 568,'JESSICA' ,'CRINER' ,3500, 300, 39500.00 ),
( 990,'thomas' ,'stibbs' ,3500,null,null ),
( 991,'Wayne' ,'O''Neil' ,3500,null,null ),
( 992,'Barry' ,'Kinney' ,3500,null,null ),
( 993,'Paul' ,'Buskett' ,3100,null,null ),
( 994,'Emmy' ,'Buskett' ,3100,null,null ),
( 995,'Walt' ,'Farley' ,3100,null,null );
UPDATE STATISTICS FOR TABLE persnl.employee ON EVERY COLUMN;
DEPT Table
CREATE TABLE persnl.dept (
deptnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,deptname CHARACTER (12)
NO DEFAULT
NOT NULL
,manager NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,rptdept NUMERIC (4) UNSIGNED
DEFAULT 0
NOT NULL
PERSNL Schema 109