spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKCTACONPAG'; delete from tConstraintsResultado where constraintname='FKCTACONPAGESTOPE'; delete from tConstraintsResultado where constraintname='IPKCONTPAGOS'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKCTACONPAG'; delete from tConstraintsResultadoId where constraintname='FKCTACONPAGESTOPE'; delete from tConstraintsResultadoId where constraintname='IPKCONTPAGOS'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKCTACONPAG','2291','505382'); insert into tConstraintsResultadoId values('FKCTACONPAGESTOPE','2291','505383'); insert into tConstraintsResultadoId values('IPKCONTPAGOS','1','505391'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','FKCTACONPAG',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 TCUENTACONTADORPAGOS EN TCUENTAID'); insert into tConstraintsResultado values('ES','FKCTACONPAGESTOPE',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 TCUENTACONTADORPAGOS EN TESTADOOPERACIONID'); insert into tConstraintsResultado values('ES','IPKCONTPAGOS',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 TCUENTACONTADORPAGOS'); commit; set Define "&" set feedback on prompt Done. spool off