spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKEVENTOCANCELACION'; delete from tConstraintsResultado where constraintname='IPKCONREPMULPAR'; delete from tConstraintsResultado where constraintname='IPKESTPORTCRE'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKEVENTOCANCELACION'; delete from tConstraintsResultadoId where constraintname='IPKCONREPMULPAR'; delete from tConstraintsResultadoId where constraintname='IPKESTPORTCRE'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKEVENTOCANCELACION','2290','505608'); insert into tConstraintsResultadoId values('IPKCONREPMULPAR','1','505606'); insert into tConstraintsResultadoId values('IPKESTPORTCRE','1','505607'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','CKEVENTOCANCELACION',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 TCUENTAPARADESEMBOLSO.EVENTOCANCELACION in (N,P,D,C,R,A)'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKCONREPMULPAR',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 TCONSULTAREPORTEMULTIPARAMETRO'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKESTPORTCRE',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 TESTRUCTURAPORTAFOLIOCREDITO'); commit; set Define "&" set feedback on prompt Done. spool off