db2 表分区实例.docxVIP

drop table MIBS.IMAGEINFO_HIS;CREATE TABLE MIBS.IMAGEINFO_HIS (ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20, MINVALUE 1, MAXVALUE 9223372036854775807, NO CYCLE, NO ORDER), BATCHNUM INTEGER, STORETIME DATE NOT NULL, IMAGEPATH VARCHAR(500), IMAGESTAMP VARCHAR(1) NOT NULL, SCANTYPE SMALLINT NOT NULL, USERFLAG SMALLINT NOT NULL, IMAGEOBJECT BLOB LOGGED NOT COMPACT, FACEFLAG VARC