spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKAJUSTEPORDECIMALES'; delete from tConstraintsResultado where constraintname='CKNUMERODECIMALESCAT'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKAJUSTEPORDECIMALES'; delete from tConstraintsResultadoId where constraintname='CKNUMERODECIMALESCAT'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKAJUSTEPORDECIMALES','2290','505401'); insert into tConstraintsResultadoId values('CKNUMERODECIMALESCAT','2290','505402'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','CKAJUSTEPORDECIMALES',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 TTRANSACCIONRUBROSDEFINICION.AJUSTEPORDECIMALES in (1,0)'); insert into tConstraintsResultado values('ES','CKNUMERODECIMALESCAT',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 TCATEGORIASDETALLE.NUMERODECIMALES between 0 and 6'); commit; set Define "&" set feedback on prompt Done. spool off