spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKCTAINVCTACOB'; delete from tConstraintsResultado where constraintname='FKCTAINVCTAPAG'; delete from tConstraintsResultado where constraintname='FKCTAINVCUP'; delete from tConstraintsResultado where constraintname='FKCTAINVPERCUS'; delete from tConstraintsResultado where constraintname='FKCTAINVPEREMI'; delete from tConstraintsResultado where constraintname='FKCTAINVPERVEN'; delete from tConstraintsResultado where constraintname='IPKCTAINVCUPON'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKCTAINVCTACOB'; delete from tConstraintsResultadoId where constraintname='FKCTAINVCTAPAG'; delete from tConstraintsResultadoId where constraintname='FKCTAINVCUP'; delete from tConstraintsResultadoId where constraintname='FKCTAINVPERCUS'; delete from tConstraintsResultadoId where constraintname='FKCTAINVPEREMI'; delete from tConstraintsResultadoId where constraintname='FKCTAINVPERVEN'; delete from tConstraintsResultadoId where constraintname='IPKCTAINVCUPON'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKCTAINVCTACOB','2291','505493'); insert into tConstraintsResultadoId values('FKCTAINVCTAPAG','2291','505494'); insert into tConstraintsResultadoId values('FKCTAINVCUP','2291','505495'); insert into tConstraintsResultadoId values('FKCTAINVPERCUS','2291','505496'); insert into tConstraintsResultadoId values('FKCTAINVPEREMI','2291','505497'); insert into tConstraintsResultadoId values('FKCTAINVPERVEN','2291','505498'); insert into tConstraintsResultadoId values('IPKCTAINVCUPON','1','505502'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVCTACOB',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 TCUENTAINVERSIONES EN TCUENTASVISTAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVCTAPAG',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 TCUENTAINVERSIONES EN TCUENTASVISTAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVCUP',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 TCUENTAINVERSIONESCUPONES EN TSUBCUENTASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVPERCUS',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 TCUENTAINVERSIONES EN TPERSONAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVPEREMI',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 TCUENTAINVERSIONES EN TPERSONAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVPERVEN',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 TCUENTAINVERSIONES EN TPERSONAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKCTAINVCUPON',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 TCUENTAINVERSIONESCUPONES'); commit; set Define "&" set feedback on prompt Done. spool off