IBM 7.2.1 Manual de usuario descargar pdf (Pagina 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

Sin comentarios

IBM 7.2.1 Manual de usuario Pagina 13