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

SALES Schema
The SALES schema stores customer and sales data.
CUSTOMER Table
CREATE TABLE sales.customer (
custnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,custname CHARACTER (18)
NO DEFAULT
NOT NULL
,street CHARACTER (22)
NO DEFAULT
NOT NULL
,city CHARACTER (14)
NO DEFAULT
NOT NULL
,state CHARACTER (12)
DEFAULT ' '
NOT NULL
,postcode CHARACTER (10)
NO DEFAULT
NOT NULL
,credit CHARACTER (2)
DEFAULT 'C1'
NOT NULL
,PRIMARY KEY (custnum)
);
INSERT INTO sales.customer
VALUES ( 21,'CENTRAL UNIVERSITY','UNIVERSITY WAY'
,'PHILADELPHIA' ,'PENNSYLVANIA','19104' ,'A1' ),
( 123,'BROWN MEDICAL CO' ,'100 CALIFORNIA STREET'
,'SAN FRANCISCO','CALIFORNIA' ,'94944' ,'C2' ),
( 143,'STEVENS SUPPLY' ,'2020 HARRIS STREET'
,'DENVER' ,'COLORADO' ,'80734' ,'A2' ),
( 324,'PREMIER INSURANCE' ,'3300 WARBASH'
,'LUBBOCK' ,'TEXAS' ,'76308' ,'A1' ),
( 543,'FRESNO STATE BANK' ,'2300 BROWN BLVD'
,'FRESNO' ,'CALIFORNIA' ,'93921' ,'B3' ),
( 926,'METALL-AG.' ,'12 WAGNERRING'
,'FRANKFURT' ,'WEST GERMANY','34' ,'D4' ),
(1234,'DATASPEED' ,'300 SAN GABRIEL WAY'
,'NEW YORK' ,'NEW YORK' ,'10014' ,'C1' ),
(3210,'BESTFOOD MARKETS' ,'3333 PHELPS STREET'
,'LINCOLN' ,'NEBRASKA' ,'68134' ,'A4' ),
(3333,'NATIONAL UTILITIES','6500 TRANS-CANADIENNE'
,'QUEBEC' ,'CANADA' ,'H4T 1X4' ,'A1' ),
114 Sample Database