IBM 7.2.1 manual Create table Orders, CHARACTERSmallint VARCHARSmallint BLOBSmallint

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