On Monday, November 19, 2018 at 11:46:10 PM UTC+7, Noel Grandin wrote: > > > what I really want is a set of SQL commands that recreates the problem. > > i.e. a small script that creates just the necessary tables and runs the > problematic query >
I have created such a script (the needed tables and indexes and full set of data) and was not able to trigger that problem. So I have closed and re-opened the H2 database and also have not been able to trigger that problem again. Sorry for wasting your time. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
test.mv.db
Description: Binary data
CREATE SCHEMA cfe;
CREATE TABLE cfe.INSTRUMENT_REF
(
ID_INSTRUMENT VARCHAR(40) NOT NULL
, ID_INSTRUMENT_REF DECIMAL(9) NOT NULL
);
CREATE UNIQUE INDEX instrument_ref_idx1
ON cfe.instrument_ref(ID_INSTRUMENT);
CREATE UNIQUE INDEX primary_key_f
ON cfe.instrument_ref(ID_INSTRUMENT_REF);
CREATE TABLE cfe.COLLATERAL_REF
(
ID_COLLATERAL_REF DECIMAL(9) NOT NULL
, ID_COLLATERAL VARCHAR(40) NULL
);
CREATE UNIQUE INDEX collateral_ref_idx1
ON cfe.collateral_ref(ID_COLLATERAL_REF);
CREATE UNIQUE INDEX collateral_ref_idx2
ON cfe.collateral_ref(ID_COLLATERAL);
CREATE UNIQUE INDEX collateral_ref_idx3
ON cfe.collateral_ref(ID_COLLATERAL_REF, ID_COLLATERAL);
CREATE TABLE cfe.INSTRUMENT
(
ID_INSTRUMENT VARCHAR(40) NOT NULL
, ID_INSTRUMENT_COMMITMENT VARCHAR(40) NULL
, ID_INSTRUMENT_TYPE VARCHAR(12) NOT NULL
, START_DATE DATE NOT NULL
, END_DATE DATE NULL
, ID_CURRENCY VARCHAR(3) NOT NULL
, ID_CALENDAR VARCHAR(12) NULL
, ID_BUSINESS_DAY_CONVENTION VARCHAR(12) NULL
, DISCOUNT_CURVE VARCHAR(12) NULL
, DISCOUNT_SPREAD VARCHAR(12) NULL
);
CREATE INDEX constraint_index_7
ON cfe.instrument(ID_INSTRUMENT_TYPE);
CREATE INDEX constraint_index_70
ON cfe.instrument(ID_BUSINESS_DAY_CONVENTION);
CREATE INDEX constraint_index_701
ON cfe.instrument(ID_CURRENCY);
CREATE INDEX constraint_index_7017
ON cfe.instrument(ID_CALENDAR);
CREATE UNIQUE INDEX instrument_idx1
ON cfe.instrument(ID_INSTRUMENT, ID_INSTRUMENT_COMMITMENT);
CREATE UNIQUE INDEX primary_key_70
ON cfe.instrument(ID_INSTRUMENT);
/*
ALTER TABLE CFE.INSTRUMENT
ADD FOREIGN KEY (ID_CALENDAR) REFERENCES CFE.CALENDAR (ID_CALENDAR);
ALTER TABLE CFE.INSTRUMENT
ADD FOREIGN KEY (ID_BUSINESS_DAY_CONVENTION) REFERENCES CFE.SYS_BUSINESS_DAY_CONVENTION (ID_BUSINESS_DAY_CONVENTION);
ALTER TABLE CFE.INSTRUMENT
ADD FOREIGN KEY (ID_CURRENCY) REFERENCES COMMON.CURRENCY (ID_CURRENCY);
ALTER TABLE CFE.INSTRUMENT
ADD FOREIGN KEY (ID_INSTRUMENT_TYPE) REFERENCES COMMON.SYS_INSTRUMENT_TYPE (ID_INSTRUMENT_TYPE);
*/
CREATE TABLE cfe.INSTRUMENT_COLLATERAL_HST
(
ID_INSTRUMENT_REF DECIMAL(9) NOT NULL
, ID_COLLATERAL_REF DECIMAL(9) NOT NULL
, VALID_DATE DATE NOT NULL
, PRIORITY DECIMAL(1) NOT NULL
, LIMIT_AMOUNT DECIMAL(23, 5) NULL
, ID_CURRENCY VARCHAR(3) NULL
, END_DATE DATE NULL
);
CREATE INDEX constraint_ab7_index_a
ON cfe.instrument_collateral_hst(ID_COLLATERAL_REF);
CREATE INDEX constraint_ab_index_a
ON cfe.instrument_collateral_hst(ID_INSTRUMENT_REF);
CREATE INDEX constraint_index_ab
ON cfe.instrument_collateral_hst(ID_CURRENCY);
CREATE INDEX instrument_collateral_hst_idx1
ON cfe.instrument_collateral_hst(ID_INSTRUMENT_REF, VALID_DATE);
CREATE INDEX instrument_collateral_hst_idx2
ON cfe.instrument_collateral_hst(ID_COLLATERAL_REF, VALID_DATE);
CREATE UNIQUE INDEX instrument_collateral_hst_idx3
ON cfe.instrument_collateral_hst(ID_INSTRUMENT_REF, ID_COLLATERAL_REF, VALID_DATE);
/*
ALTER TABLE CFE.INSTRUMENT_COLLATERAL_HST
ADD FOREIGN KEY (ID_COLLATERAL_REF) REFERENCES CFE.COLLATERAL_REF (ID_COLLATERAL_REF);
ALTER TABLE CFE.INSTRUMENT_COLLATERAL_HST
ADD FOREIGN KEY (ID_INSTRUMENT_REF) REFERENCES CFE.INSTRUMENT_REF (ID_INSTRUMENT_REF);
ALTER TABLE CFE.INSTRUMENT_COLLATERAL_HST
ADD FOREIGN KEY (ID_CURRENCY) REFERENCES COMMON.CURRENCY (ID_CURRENCY);
*/
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('2990003709'
, 4413);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180511000050'
, 8835);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920160720000018'
, 284);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('2990001956'
, 4254);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180123000035'
, 4601);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990013321'
, 3862);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990003692'
, 3703);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180315000159'
, 8078);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180608000017'
, 9203);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180109000057'
, 4593);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990010399'
, 3827);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920160831000015'
, 305);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920170913000239'
, 336);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('2990001152'
, 4174);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920171222000273'
, 4589);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('2990001138'
, 4172);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990004668'
, 6350);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920160721000015'
, 299);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990007102'
, 6569);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920171102000034'
, 4523);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920170504000206'
, 4490);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920160720000281'
, 295);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920160720000236'
, 293);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990010502'
, 6823);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990007470'
, 6606);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990003252'
, 3683);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180507000017'
, 8722);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('2990001341'
, 4193);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990005940'
, 6460);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990016906'
, 7965);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990012489'
, 3836);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990012496'
, 7007);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180509000066'
, 8805);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990016748'
, 7488);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920161027000116'
, 312);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990003685'
, 3702);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920161010000031'
, 310);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990004376'
, 6324);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990006961'
, 6555);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920170915000039'
, 337);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990001904'
, 6157);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920160830000326'
, 302);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920171102000058'
, 4524);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990002389'
, 3661);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990007487'
, 6607);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180419000039'
, 8585);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990010241'
, 3816);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('2990001107'
, 4169);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990003300'
, 3686);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990007054'
, 6564);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920170524000165'
, 325);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920160720000212'
, 292);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('2990002300'
, 4289);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920171102000010'
, 4522);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('9920180509000073'
, 8806);
INSERT INTO cfe.instrument_ref
("ID_INSTRUMENT"
, "ID_INSTRUMENT_REF")
VALUES ('1990007133'
, 6572);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990003685'
, NULL
, 'curr_acc'
, {d '2016-04-18'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('2990001956'
, NULL
, 'curr_acc'
, {d '2010-02-17'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920170913000239'
, NULL
, 'loan_bmr'
, {d '2017-09-13'}
, {d '2020-08-21'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920161027000116'
, NULL
, 'loan_bmr'
, {d '2016-10-26'}
, {d '2018-03-16'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('2990001138'
, NULL
, 'curr_acc'
, {d '2011-06-14'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920161010000031'
, NULL
, 'loan_bmr'
, {d '2016-10-10'}
, {d '2019-09-21'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990003300'
, NULL
, 'curr_acc'
, {d '2016-04-14'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990005940'
, NULL
, 'curr_acc'
, {d '2014-02-13'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990004376'
, NULL
, 'curr_acc'
, {d '2012-07-03'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990010399'
, NULL
, 'curr_acc'
, {d '2016-01-27'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920170524000165'
, NULL
, 'loan_bmr'
, {d '2017-05-01'}
, {d '2018-01-11'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920171102000058'
, NULL
, 'loan'
, {d '2017-10-27'}
, {d '2018-02-05'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920170915000039'
, NULL
, 'loan_bmr'
, {d '2017-09-13'}
, {d '2020-09-01'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180509000073'
, NULL
, 'loan'
, {d '2018-05-08'}
, {d '2018-11-05'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920160830000326'
, NULL
, 'loan_bmr'
, {d '2016-05-01'}
, {d '2018-05-09'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180123000035'
, NULL
, 'loan'
, {d '2018-01-22'}
, {d '2019-01-22'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920160721000015'
, NULL
, 'loan_bmr'
, {d '2016-06-22'}
, {d '2016-09-21'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990007470'
, NULL
, 'curr_acc'
, {d '2016-10-27'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180507000017'
, NULL
, 'curr_acc'
, {d '2018-05-07'}
, {d '2018-05-14'}
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990010241'
, NULL
, 'curr_acc'
, {d '2016-04-18'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990007054'
, NULL
, 'curr_acc'
, {d '2016-10-26'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990007133'
, NULL
, 'curr_acc'
, {d '2016-10-26'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920160720000281'
, NULL
, 'loan_bmr'
, {d '2016-06-22'}
, {d '2019-02-21'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('2990001341'
, NULL
, 'curr_acc'
, {d '2012-04-24'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990004668'
, NULL
, 'curr_acc'
, {d '2016-05-11'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180511000050'
, NULL
, 'loan'
, {d '2018-05-11'}
, {d '2018-08-09'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920170504000206'
, NULL
, 'loan'
, {d '2017-05-01'}
, {d '2018-01-29'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920160720000212'
, NULL
, 'loan_bmr'
, {d '2016-06-22'}
, {d '2023-09-21'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990002389'
, NULL
, 'curr_acc'
, {d '2016-02-01'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('2990001107'
, NULL
, 'curr_acc'
, {d '2011-03-01'}
, {d '2018-04-16'}
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990006961'
, NULL
, 'curr_acc'
, {d '2016-10-25'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990003692'
, NULL
, 'curr_acc'
, {d '2016-04-18'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990003252'
, NULL
, 'curr_acc'
, {d '2016-04-14'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990016906'
, NULL
, 'curr_acc'
, {d '2018-03-14'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180419000039'
, NULL
, 'loan'
, {d '2018-04-18'}
, {d '2018-07-17'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920160831000015'
, NULL
, 'loan_bmr'
, {d '2016-05-01'}
, {d '2025-01-01'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990016748'
, NULL
, 'curr_acc'
, {d '2018-02-13'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920171102000010'
, NULL
, 'loan'
, {d '2017-10-27'}
, {d '2018-02-05'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180109000057'
, NULL
, 'loan'
, {d '2018-01-09'}
, {d '2019-01-09'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('2990003709'
, NULL
, 'curr_acc'
, {d '2015-10-02'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990012489'
, NULL
, 'curr_acc'
, {d '2016-02-05'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920171102000034'
, NULL
, 'loan'
, {d '2017-10-27'}
, {d '2018-02-05'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990013321'
, NULL
, 'curr_acc'
, {d '2016-04-15'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990010502'
, NULL
, 'curr_acc'
, {d '2015-09-08'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180608000017'
, NULL
, 'loan'
, {d '2018-06-08'}
, {d '2018-08-07'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920160720000236'
, NULL
, 'loan_bmr'
, {d '2016-06-22'}
, {d '2025-01-21'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990001904'
, NULL
, 'curr_acc'
, {d '2015-11-10'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990012496'
, NULL
, 'curr_acc'
, {d '2016-02-11'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('2990002300'
, NULL
, 'curr_acc'
, {d '2013-12-04'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990007102'
, NULL
, 'curr_acc'
, {d '2016-10-26'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('1990007487'
, NULL
, 'curr_acc'
, {d '2016-10-27'}
, NULL
, 'USD'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('2990001152'
, NULL
, 'curr_acc'
, {d '2011-07-20'}
, NULL
, 'NGN'
, 'DEFAULT'
, 'I'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180509000066'
, NULL
, 'loan'
, {d '2018-05-08'}
, {d '2018-11-05'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920180315000159'
, NULL
, 'loan_bmr'
, {d '2018-03-15'}
, {d '2020-01-01'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.instrument
("ID_INSTRUMENT"
, "ID_INSTRUMENT_COMMITMENT"
, "ID_INSTRUMENT_TYPE"
, "START_DATE"
, "END_DATE"
, "ID_CURRENCY"
, "ID_CALENDAR"
, "ID_BUSINESS_DAY_CONVENTION"
, "DISCOUNT_CURVE"
, "DISCOUNT_SPREAD")
VALUES ('9920171222000273'
, NULL
, 'loan'
, {d '2017-12-22'}
, {d '2018-12-24'}
, 'NGN'
, NULL
, 'N'
, NULL
, NULL);
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (31
, 'C000373');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (30
, 'C000214');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (44
, 'R001621');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (43
, 'R000237');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (41
, 'R000233');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (24
, 'R000469');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (7
, 'C000342');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (6
, 'C000346');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (22
, 'R000487');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (38
, 'R000295');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (18
, 'R000222');
INSERT INTO cfe.collateral_ref
("ID_COLLATERAL_REF"
, "ID_COLLATERAL")
VALUES (34
, 'C000297');
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4413
, 38
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (8835
, 31
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (284
, 22
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4254
, 44
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4601
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3862
, 44
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3703
, 22
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (8078
, 18
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (9203
, 34
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4593
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3827
, 6
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (305
, 43
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (336
, 24
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4174
, 43
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4589
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4172
, 41
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6350
, 34
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (299
, 41
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6569
, 41
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4523
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4490
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (295
, 38
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (293
, 43
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6823
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6606
, 38
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3683
, 41
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (8722
, 18
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4193
, 38
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6460
, 24
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (7965
, 18
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3836
, 34
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (7007
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (8805
, 6
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (7488
, 34
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (312
, 18
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3702
, 24
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (310
, 41
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6324
, 38
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6555
, 22
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (337
, 24
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6157
, 7
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (302
, 22
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4524
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3661
, 31
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6607
, 43
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (8585
, 34
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3816
, 43
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4169
, 18
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (3686
, 38
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6564
, 44
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (325
, 44
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (292
, 22
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4289
, 22
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (4522
, 30
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (8806
, 6
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
INSERT INTO cfe.instrument_collateral_hst
("ID_INSTRUMENT_REF"
, "ID_COLLATERAL_REF"
, "VALID_DATE"
, "PRIORITY"
, "LIMIT_AMOUNT"
, "ID_CURRENCY"
, "END_DATE")
VALUES (6572
, 24
, {d '2018-11-19'}
, 1
, NULL
, NULL
, NULL);
SELECT /*+PARALLEL*/ b.ID_INSTRUMENT
, c.ID_COLLATERAL
, a.VALID_DATE
, a.PRIORITY
, a.LIMIT_AMOUNT
, a.ID_CURRENCY
, a.END_DATE
FROM cfe.INSTRUMENT_COLLATERAL_HST a
INNER JOIN cfe.INSTRUMENT_REF b
ON a.id_instrument_ref = b.id_instrument_ref
INNER JOIN cfe.COLLATERAL_REF c
ON a.id_collateral_ref = c.id_collateral_ref
INNER JOIN cfe.instrument d
ON b.id_instrument = d.id_instrument
WHERE valid_date = (SELECT Max(valid_date)
FROM cfe.INSTRUMENT_COLLATERAL_HST
WHERE ID_COLLATERAL_REF = a.ID_COLLATERAL_REF
AND valid_date <= {d '2018-12-12'})
