delete tcomandosmantenimiento where comando = 'com.fitbank.loan.acco.restructure.maintenance'; delete tcomandosid where comando = 'com.fitbank.loan.acco.restructure.maintenance'; update tcomandosmantenimiento set scomando = 1 , orden = 1 where csubsistema = '03' and ctransaccion = '6601' and scomando =3; insert into tcomandosid values('com.fitbank.loan.acco.restructure.maintenance.CancelAccount','MAN'); insert into tcomandosmantenimiento (CSUBSISTEMA,CTRANSACCION,VERSIONTRANSACCION,SCOMANDO,EVENTO,COMANDO,ORDEN,USACACHE,TIPOCOMANDO, ACTIVADO,CANALESEXCLUIDOS,PARAMETRO,VERSIONCONTROL,EJECUTADOPOR) values('03','6601','01',2,'I','com.fitbank.loan.acco.restructure.maintenance.CancelAccount',1,'0','MAN', '1',null,null,0,null);