Db2 everyplace characteristics, Create table – IBM DB2 Everyplace 7.2.1 User Manual
Page 13
Advertising
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
Advertising