spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKMICROEMPRESACLA'; delete from tConstraintsResultado where constraintname='CKMICROEMPRESATIP'; delete from tConstraintsResultado where constraintname='FKJURBASFRECREU'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKMICROEMPRESACLA'; delete from tConstraintsResultadoId where constraintname='CKMICROEMPRESATIP'; delete from tConstraintsResultadoId where constraintname='FKJURBASFRECREU'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKMICROEMPRESACLA','2290','505301'); insert into tConstraintsResultadoId values('CKMICROEMPRESATIP','2290','505299'); insert into tConstraintsResultadoId values('FKJURBASFRECREU','2291','505300'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','CKMICROEMPRESACLA',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'),'FUERA DE LOS VALORES PERMITIDOS PARA TCLASESEMPRESAID.MICROEMPRESA = upper(MICROEMPRESA) and MICROEMPRESA in (1,0)'); insert into tConstraintsResultado values('ES','CKMICROEMPRESATIP',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'),'FUERA DE LOS VALORES PERMITIDOS PARA TTIPOSEMPRESAID.MICROEMPRESA = upper(MICROEMPRESA) and MICROEMPRESA in (1,0)'); insert into tConstraintsResultado values('ES','FKJURBASFRECREU',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 TJURIDICOINFORMACIONBASICA EN TFRECUENCIASID'); commit; set Define "&" set feedback on prompt Done. spool off