HP c-tree-SQL ISQL and Tools Manuel d'utilisateur télécharger pdf (Page 91)

FairCom Corporation A-1

Appendix A

Tutorial Source Code

A.1 INTRODUCTORY TUTORIAL

CREATE TABLE CUSTMAST (

cm_custnum VARCHAR(5),

cm_zip VARCHAR(10),

cm_state VARCHAR(3),

cm_rating VARCHAR(2),

cm_name VARCHAR(48),

cm_address VARCHAR(48),

cm_city VARCHAR(48) );

COMMIT WORK;

INSERT INTO CUSTMAST VALUES ('1000', '92867', 'CA', '1', 'Bryan

Williams', '2999 Regency', 'Orange');

INSERT INTO CUSTMAST VALUES ('1001', '61434', 'CT', '1', 'Michael

Jordan', '13 Main', 'Harford');

INSERT INTO CUSTMAST VALUES ('1002', '73677', 'GA', '1', 'Joshua

Brown', '4356 Cambridge', 'Atlanta');

INSERT INTO CUSTMAST VALUES ('1003', '10034', 'MO', '1', 'Keyon

Dooling', '19771 Park Avenue', 'Columbia');

COMMIT WORK;

SELECT * FROM CUSTMAST;

DELETE FROM CUSTMAST;

COMMIT WORK;

SELECT * FROM CUSTMAST;

A.2 RELATIONAL MODEL AND INDEXING TUTORIAL

CREATE TABLE orderlist (

ol_orderdate DATE,

ol_promdate DATE,

ol_ordernum VARCHAR(7),

ol_custnum VARCHAR(4) );

CREATE INDEX custorder ON orderlist (ol_ordernum, ol_custnum);

CREATE TABLE orderitems (

oi_ordernum VARCHAR(7),

oi_seqnumber SMALLINT,

oi_quantity SMALLINT,

1 2 ... 86 87 88 89 90 91 92 93 94 95 96 97 98 99

Pas de commentaire

HP c-tree-SQL ISQL and Tools Manuel d'utilisateur Page 91