begin transaction go

exec sp_passthrough_piece ’CREATE TABLE DBA.employee

(

emp_id integer NOT NULL, manager_id integer NULL, emp_fname char(20) NOT NULL, emp_lname char(20) NOT NULL,’

go

exec sp_passthrough_piece ’ dept_id integer NOT NULL, street char(40) NOT NULL, city char(20) NOT NULL, state char(4) NOT NULL, zip_code char(9) NOT NULL, phone char(10) NULL,’

go

exec sp_passthrough_piece ’status char(1) NULL, ss_number char(11) NOT NULL,

salary numeric(20,3) NOT NULL, start_date date NOT NULL, termination_date date NULL, birth_date date NULL,’

go

exec sp_passthrough ’ bene_health_ins char(1) NULL, bene_life_ins char(1) NULL, bene_day_care char(1) NULL, sex char(1) NULL,

PRIMARY KEY (emp_id), )’

go commit go

404

Page 422
Image 422
Sybase DC38133-01-0902-01 manual 404