IBM 7.2.1 User Manual download pdf (Page 13)

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

1 2 ... 8 9 10 11 12 13 14 15 16 17 18

No comments

IBM 7.2.1 User Manual Page 13