DB2 Everyplace Characteristics
CREATE TABLE
withfollowing datatypes
INTEGER |
SMALLINT
DECIMAL(Big)

CHARACTER(Smallint)

VARCHAR(Smallint)

BLOB(Smallint)

DATE
TIME
TIMESTAMP
andoptions
PRIMARYKEY with more than one column
referentialconstraints
CHECKconstraints
CREATE TABLE

create table ORDERS

(CUSTNO CHAR(6) NOTNULL,
ENTRY TIMESTAMP NOT NULL DEFAULT Current Timestamp,
ITEM CHAR(15),
PRICE DECIMAL(9,2),
Check (Price< 100),
PRIMARYKEY (CUSTNO,ENTRY))
Page 25-26