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

( 9000,'CORPORATE' , 1,9000,'CHICAGO' );
UPDATE STATISTICS FOR TABLE persnl.dept ON EVERY COLUMN;
PROJECT Table
CREATE TABLE persnl.project (
projcode NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,empnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,projdesc VARCHAR (18)
DEFAULT ' '
NOT NULL
,start_date DATE
DEFAULT DATE '2002-07-01'
NOT NULL
,ship_timestamp TIMESTAMP
DEFAULT TIMESTAMP '2002-08-01:12:00:00.000000'
NOT NULL
,est_complete INTERVAL DAY
DEFAULT INTERVAL '30' DAY
NOT NULL
,PRIMARY KEY (projcode,empnum)
);
INSERT INTO persnl.project
VALUES ( 1000,213,'SALT LAKE CITY'
,DATE '2002-04-10'
,TIMESTAMP '2002-04-21:08:15:00.00'
,INTERVAL '15' DAY ),
( 1000,211,'SALT LAKE CITY'
,DATE '2002-04-10'
,TIMESTAMP '2002-04-21:08:15:00.00'
,INTERVAL '15' DAY ),
( 1000,23,'SALT LAKE CITY'
,DATE '2002-04-10'
,TIMESTAMP '2002-04-21:08:15:00.00'
,INTERVAL '15' DAY ),
( 1000,1,'SALT LAKE CITY'
,DATE '2002-04-10'
,TIMESTAMP '2002-04-21:08:15:00.00'
,INTERVAL '15' DAY ),
( 2000,227,'ROSS PRODUCTS'
,DATE '2002-06-10'
,TIMESTAMP '2002-07-21:08:30:00.0000'
,INTERVAL '30' DAY ),
( 2000,109,'ROSS PRODUCTS'
,DATE '2002-06-10'
,TIMESTAMP '2002-07-21:08:30:00.0000'
,INTERVAL '30' DAY ),
PERSNL Schema 111