CREATE TABLE TABLE1( DATE CHAR(8) NOT NULL CONSTRAINT CHK_TBL1 CHECK ( DATE='20160101') DEFAULT '', PRICE DECIMAL(15,4) NOT NULL DEFAULT 0);CREATE VIEW TEST AS SELECT DATE,PRICE FROM TABLE1UNION ALL ...
显示全部CREATE TABLE TABLE1
(
DATE CHAR(8) NOT NULL CONSTRAINT CHK_TBL1 CHECK ( DATE<'20160101') DEFAULT '',
PRICE DECIMAL(19,4) NOT NULL DEFAULT 0
);
CREATE TABLE TABLE2
(
DATE CHAR(8) NOT NULL CONSTRAINT CHK_TBL1 CHECK ( DATE>='20160101') DEFAULT '',
PRICE DECIMAL(15,4) NOT NULL DEFAULT 0
);
CREATE VIEW TEST AS
SELECT DATE,PRICE FROM TABLE1
UNION ALL SELECT DATE,PRICE FROM TABLE2;
INSERT INTO TEST (DATE,PRICE)
VALUES('20150101',3.14);
----------
SQL0151N 不能更新列 "PRICE"。 SQLSTATE=42808
有没有在不改基表字段类型的情况下,使字段兼容?
或者能明确DB2不允许这样做,谢谢
收起