-- Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKRENTAFIJAVARIABLE'; delete from tConstraintsResultado where constraintname='CKRENTAFIJAVARIABLECI'; delete from tConstraintsResultado where constraintname='CKTIENECUPON'; delete from tConstraintsResultado where constraintname='CKTIENECUPONCI'; delete from tConstraintsResultado where constraintname='FKCTAINVBASCALC'; delete from tConstraintsResultado where constraintname='FKCTAINVCALIF'; delete from tConstraintsResultado where constraintname='FKCTAINVCALIFPER1'; delete from tConstraintsResultado where constraintname='FKCTAINVCALIFPER2'; delete from tConstraintsResultado where constraintname='FKCTAINVCALIFPER3'; delete from tConstraintsResultado where constraintname='FKCTAINVFREQCUP'; delete from tConstraintsResultado where constraintname='FKCTAINVFREQREV'; delete from tConstraintsResultado where constraintname='FKCTAINVTIPMERC'; delete from tConstraintsResultado where constraintname='FKEMICUPOINV'; delete from tConstraintsResultado where constraintname='FKEMICUPOINVMON'; delete from tConstraintsResultado where constraintname='FKIDITIPMERC'; delete from tConstraintsResultado where constraintname='FKTIPCLICUPOINV'; delete from tConstraintsResultado where constraintname='FKTIPCLICUPOINVMON'; delete from tConstraintsResultado where constraintname='FKTIPMERCID'; delete from tConstraintsResultado where constraintname='FKTITVALBASCALC'; delete from tConstraintsResultado where constraintname='FKTITVALFREQREV'; delete from tConstraintsResultado where constraintname='FKTITVALTIPINST'; delete from tConstraintsResultado where constraintname='FKTITVALTIPMERC'; delete from tConstraintsResultado where constraintname='FKTITVALTIPPORT'; delete from tConstraintsResultado where constraintname='IPKCTAINVCALIF'; delete from tConstraintsResultado where constraintname='IPKEMICUPOINV'; delete from tConstraintsResultado where constraintname='IPKTIPCLICUPOINV'; delete from tConstraintsResultado where constraintname='IPKTIPMERC'; delete from tConstraintsResultado where constraintname='IPKTIPMERCID'; delete from tConstraintsResultado where constraintname='IPKTITVALCARACT'; -- Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKRENTAFIJAVARIABLE'; delete from tConstraintsResultadoId where constraintname='CKRENTAFIJAVARIABLECI'; delete from tConstraintsResultadoId where constraintname='CKTIENECUPON'; delete from tConstraintsResultadoId where constraintname='CKTIENECUPONCI'; delete from tConstraintsResultadoId where constraintname='FKCTAINVBASCALC'; delete from tConstraintsResultadoId where constraintname='FKCTAINVCALIF'; delete from tConstraintsResultadoId where constraintname='FKCTAINVCALIFPER1'; delete from tConstraintsResultadoId where constraintname='FKCTAINVCALIFPER2'; delete from tConstraintsResultadoId where constraintname='FKCTAINVCALIFPER3'; delete from tConstraintsResultadoId where constraintname='FKCTAINVFREQCUP'; delete from tConstraintsResultadoId where constraintname='FKCTAINVFREQREV'; delete from tConstraintsResultadoId where constraintname='FKCTAINVTIPMERC'; delete from tConstraintsResultadoId where constraintname='FKEMICUPOINV'; delete from tConstraintsResultadoId where constraintname='FKEMICUPOINVMON'; delete from tConstraintsResultadoId where constraintname='FKIDITIPMERC'; delete from tConstraintsResultadoId where constraintname='FKTIPCLICUPOINV'; delete from tConstraintsResultadoId where constraintname='FKTIPCLICUPOINVMON'; delete from tConstraintsResultadoId where constraintname='FKTIPMERCID'; delete from tConstraintsResultadoId where constraintname='FKTITVALBASCALC'; delete from tConstraintsResultadoId where constraintname='FKTITVALFREQREV'; delete from tConstraintsResultadoId where constraintname='FKTITVALTIPINST'; delete from tConstraintsResultadoId where constraintname='FKTITVALTIPMERC'; delete from tConstraintsResultadoId where constraintname='FKTITVALTIPPORT'; delete from tConstraintsResultadoId where constraintname='IPKCTAINVCALIF'; delete from tConstraintsResultadoId where constraintname='IPKEMICUPOINV'; delete from tConstraintsResultadoId where constraintname='IPKTIPCLICUPOINV'; delete from tConstraintsResultadoId where constraintname='IPKTIPMERC'; delete from tConstraintsResultadoId where constraintname='IPKTIPMERCID'; delete from tConstraintsResultadoId where constraintname='IPKTITVALCARACT'; -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKRENTAFIJAVARIABLE','2290','505458'); insert into tConstraintsResultadoId values('CKRENTAFIJAVARIABLECI','2290','505459'); insert into tConstraintsResultadoId values('CKTIENECUPON','2290','505460'); insert into tConstraintsResultadoId values('CKTIENECUPONCI','2290','505461'); insert into tConstraintsResultadoId values('FKCTAINVBASCALC','2291','505462'); insert into tConstraintsResultadoId values('FKCTAINVCALIF','2291','505463'); insert into tConstraintsResultadoId values('FKCTAINVCALIFPER1','2291','505464'); insert into tConstraintsResultadoId values('FKCTAINVCALIFPER2','2291','505465'); insert into tConstraintsResultadoId values('FKCTAINVCALIFPER3','2291','505466'); insert into tConstraintsResultadoId values('FKCTAINVFREQCUP','2291','505467'); insert into tConstraintsResultadoId values('FKCTAINVFREQREV','2291','505468'); insert into tConstraintsResultadoId values('FKCTAINVTIPMERC','2291','505469'); insert into tConstraintsResultadoId values('FKEMICUPOINV','2291','505470'); insert into tConstraintsResultadoId values('FKEMICUPOINVMON','2291','505471'); insert into tConstraintsResultadoId values('FKIDITIPMERC','2291','505473'); insert into tConstraintsResultadoId values('FKTIPCLICUPOINV','2291','505475'); insert into tConstraintsResultadoId values('FKTIPCLICUPOINVMON','2291','505476'); insert into tConstraintsResultadoId values('FKTIPMERCID','2291','505477'); insert into tConstraintsResultadoId values('FKTITVALBASCALC','2291','505478'); insert into tConstraintsResultadoId values('FKTITVALFREQREV','2291','505479'); insert into tConstraintsResultadoId values('FKTITVALTIPINST','2291','505480'); insert into tConstraintsResultadoId values('FKTITVALTIPMERC','2291','505481'); insert into tConstraintsResultadoId values('FKTITVALTIPPORT','2291','505482'); insert into tConstraintsResultadoId values('IPKCTAINVCALIF','1','505484'); insert into tConstraintsResultadoId values('IPKEMICUPOINV','1','505485'); insert into tConstraintsResultadoId values('IPKTIPCLICUPOINV','1','505487'); insert into tConstraintsResultadoId values('IPKTIPMERC','1','505488'); insert into tConstraintsResultadoId values('IPKTIPMERCID','1','505489'); insert into tConstraintsResultadoId values('IPKTITVALCARACT','1','505490'); -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','CKRENTAFIJAVARIABLE',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 TTITULOSVALORCARACTERISTICAS.RENTAFIJAVARIABLE = upper(RENTAFIJAVARIABLE) and RENTA'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','CKRENTAFIJAVARIABLECI',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 TCUENTAINVERSIONES.RENTAFIJAVARIABLE = upper(RENTAFIJAVARIABLE) and RENTAFIJAVARIAB'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','CKTIENECUPON',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 TTITULOSVALORCARACTERISTICAS.TIENECUPON = upper(TIENECUPON) and TIENECUPON in (1,0)'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','CKTIENECUPONCI',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 TCUENTAINVERSIONES.TIENECUPON = upper(TIENECUPON) and TIENECUPON in (1,0)'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVBASCALC',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 TBASESCALCULOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVCALIF',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 TCUENTAINVERSIONESCALIFICACION EN TCUENTAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVCALIFPER1',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 TCUENTAINVERSIONESCALIFICACION EN TPERSONAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVCALIFPER2',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 TCUENTAINVERSIONESCALIFICACION EN TPERSONAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVCALIFPER3',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 TCUENTAINVERSIONESCALIFICACION EN TPERSONAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVFREQCUP',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 TFRECUENCIASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVFREQREV',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 TFRECUENCIASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINVTIPMERC',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 TTIPOSMERCADOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKEMICUPOINV',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 TEMISORESCUPOSINVERSION EN TEMISORESID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKEMICUPOINVMON',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 TEMISORESCUPOSINVERSION EN TMONEDASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKIDITIPMERC',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 TTIPOSMERCADO EN TIDIOMASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTIPCLICUPOINV',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 TTIPOSCLIENTECUPOSINVERSION EN TTIPOSCLIENTEID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTIPCLICUPOINVMON',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 TTIPOSCLIENTECUPOSINVERSION EN TMONEDASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTIPMERCID',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 TTIPOSMERCADO EN TTIPOSMERCADOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTITVALBASCALC',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 TTITULOSVALORCARACTERISTICAS EN TBASESCALCULOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTITVALFREQREV',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 TTITULOSVALORCARACTERISTICAS EN TFRECUENCIASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTITVALTIPINST',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 TTITULOSVALORCARACTERISTICAS EN TTIPOSINSTRUMENTOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTITVALTIPMERC',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 TTITULOSVALORCARACTERISTICAS EN TTIPOSMERCADOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTITVALTIPPORT',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 TTITULOSVALORCARACTERISTICAS EN TTIPOSPORTAFOLIOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKCTAINVCALIF',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 TCUENTAINVERSIONESCALIFICACION'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKEMICUPOINV',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 TEMISORESCUPOSINVERSION'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTIPCLICUPOINV',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 TTIPOSCLIENTECUPOSINVERSION'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTIPMERC',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 TTIPOSMERCADO'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTIPMERCID',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 TTIPOSMERCADOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTITVALCARACT',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 TTITULOSVALORCARACTERISTICAS'); commit; -- Done.