执行这个:
CREATE TABLE LINEITEM
( l_orderkey DECIMAL(10,0) NOT NULL,
l_partkey INTEGER,
l_suppkey INTEGER,
l_linenumber INTEGER,
l_quantity DECIMAL(12,2),
l_extendedprice DECIMAL(12,2),
l_discount DECIMAL(12,2),
l_tax DECIMAL(12,2),
l_returnflag CHAR(1),
l_linestatus CHAR(1),
l_shipdate DATE,
l_commitdate DATE,
l_receiptdate DATE,
l_shipinstruct CHAR(25),
l_shipmode CHAR(10),
l_comment VARCHAR(44))
PARTITION BY RANGE(l_shipdate)
( STARTING '1/1/1992' ENDING '30/06/1992',
STARTING '1/7/1992' ENDING '31/12/1992',
STARTING '1/1/1993' ENDING '30/6/1993',
STARTING '1/7/1993' ENDING '31/12/1993');
结果报错:
The table partitioning feature is being used without a DB2 Enterprise Server Edition license. DB2 has detected that the table partitioning feature is being used without a DB2 Enterprise Server Edition license. Ensure that you have purchased a valid DB2 Enterprise Server Edition entitlement from your IBM representative or authorized dealer and have updated your license using the db2licm command.. SQLCODE=-8027, SQLSTATE= , DRIVER=4.13.111