informix 把数据从一个表倒到另外一个表中

  drop table zrjReinUnClaimTmpT;  
	 create table zrjReinUnClaimTmpT  (  
	    mainid           SERIAL       not null,  
	    RepayNo          varchar(25)  not null,        
          comCode	         varchar(8)   not null, 
        CaseNo           varchar(25)  not null, 
        reinsType		 varchar(2)   not null, 
        casestate 		 varchar(1)   not null, 
        policyNo   	     varchar(25)  not null,  
        reinsTime        DATETIME YEAR TO SECOND,
	 primary key (mainid)  
		  constraint PK_zrjReinUnClaimTmpT
);
select * from zrjReinUnClaimTmpT;

insert into zrjReinUnClaimTmpT(RepayNo,comCode,CaseNo,reInsType,casestate,policyNo,reinsTime) select RepayNo,comCode,CaseNo,reInsType,casestate,policyNo,reinsTime from zrjReinUnClaimTmp;

drop table zrjReinUnClaimTmp;

rename table zrjReinUnClaimTmpt to zrjReinUnClaimTmp;

select * from zrjReinUnClaimTmp;

 alter table zrjSubReinTmp drop  SerialNo;

转载于:https://www.cnblogs.com/java20130726/p/3218268.html