Filter
Top Products
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