回复 5# 新数科技 建表语句如下:CREATE TABLE "SMGSST "."T_MNGSRM_TRAN_LOG1" ( "PLT_DATE" CHAR(8) NOT NULL , &...
显示全部回复 5# 新数科技 建表语句如下:
CREATE TABLE "SMGSST "."T_MNGSRM_TRAN_LOG1" (
"PLT_DATE" CHAR(8) NOT NULL ,
"PLT_SEQNO" CHAR(20) NOT NULL ,
"TRAN_STAT" CHAR(1) NOT NULL ,
"TRAN_FLAG" CHAR(1) ,
"CHNL_NO" CHAR(3) NOT NULL ,
"CHNL_SEQNO" VARCHAR(20) ,
"CHNL_DATE" CHAR(8) ,
"CHK_ACC_CODE" VARCHAR(40) ,
"OUT_TRAN_CODE" VARCHAR(20) ,
"OUT_TRAN_NAME" VARCHAR(100) ,
"INN_TRAN_CODE" VARCHAR(50) NOT NULL ,
"INN_TRAN_NAME" VARCHAR(40) NOT NULL ,
"BGN_STMP" VARCHAR(30) NOT NULL ,
"END_STMP" VARCHAR(30) ,
"USED_TIME" INTEGER ,
"ERR_CODE" VARCHAR(10) ,
"REMARK" VARCHAR(60) ,
"CLT_SEQNO" CHAR(10) ,
"CHK_ACC_FLAG" CHAR(1) NOT NULL WITH DEFAULT '0' ,
"RES_FLAG" CHAR(40) NOT NULL WITH DEFAULT '0000000000000000000000000000000000000000' ,
"SEQNO" SMALLINT NOT NULL IMPLICITLY HIDDEN GENERATED ALWAYS AS ( MOD(BIGINT(PLT_SEQNO),10) ) ,
"CURMEM" SMALLINT NOT NULL IMPLICITLY HIDDEN WITH DEFAULT CURRENT NODE )
INDEX IN "TBS_TRAN_IDX" PARTITION BY RANGE("SEQNO")
(PART "PART0" STARTING(0) ENDING(0) IN "TBS_TRAN_DATA",
PART "PART1" STARTING(1) ENDING(1) IN "TBS_TRAN_DATA",
PART "PART2" STARTING(2) ENDING(2) IN "TBS_TRAN_DATA",
PART "PART3" STARTING(3) ENDING(3) IN "TBS_TRAN_DATA",这是建表语句,确实有 HIDDEN的列,这种情况该如何导数据,才不会报错呢?
收起