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 TABLEcreate 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))