IBM 7.2.1 Manuale Utente Scaricare il pdf (Pagina 13)

DB2 Everyplace Characteristics

CREATE TABLE

with following datatypes

INTEGER |

SMALLINT

DECIMAL (Big)

CHARACTER(Smallint)

VARCHAR(Smallint)

BLOB(Smallint)

DATE

TIME

TIMESTAMP

and options

PRIMARY KEY with more than one column

referential constraints

CHECK constraints

CREATE TABLE

create table ORDERS

(CUSTNO CHAR(6) NOT NULL,

ENTRY TIMESTAMP NOT NULL DEFAULT Current Timestamp,

ITEM CHAR(15) ,

PRICE DECIMAL(9,2),

Check (Price < 100),

PRIMARY KEY (CUSTNO,ENTRY))

Page 25-26

1 2 ... 8 9 10 11 12 13 14 15 16 17 18

Nessun commento

IBM 7.2.1 Manuale Utente Pagina 13