spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKCTATASEFEC'; delete from tConstraintsResultado where constraintname='IPKCTATASEFEC'; delete from tConstraintsResultado where constraintname='FKSOLTASEFEC'; delete from tConstraintsResultado where constraintname='IPKSOLTASEFEC'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKCTATASEFEC'; delete from tConstraintsResultadoId where constraintname='IPKCTATASEFEC'; delete from tConstraintsResultadoId where constraintname='FKSOLTASEFEC'; delete from tConstraintsResultadoId where constraintname='IPKSOLTASEFEC'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKCTATASEFEC','2291','505503'); insert into tConstraintsResultadoId values('IPKCTATASEFEC','1','505507'); insert into tConstraintsResultadoId values('FKSOLTASEFEC','2291','505510'); insert into tConstraintsResultadoId values('IPKSOLTASEFEC','1','505513'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTATASEFEC',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TCUENTATASAEFECTIVA EN TCUENTAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKCTATASEFEC',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TCUENTATASAEFECTIVA'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSOLTASEFEC',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TSOLICITUDTASAEFECTIVA EN TSOLICITUDID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKSOLTASEFEC',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TSOLICITUDTASAEFECTIVA'); commit; set Define "&" set feedback on prompt Done. spool off