UPDATE data_universe_ds2 SET SecMapStartDate = '1998-11-23', SecMapEndDate = '2079-06-06' WHERE SecCode = 28777 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '2004-10-06', SecMapEndDate = '2079-06-06' WHERE SecCode = 30421 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapEndDate = '2000-01-03' WHERE SecCode = 39135 AND Type_ = 10; UPDATE data_universe_ds2 SET ISIN = NULL WHERE SecCode = 46813 AND Type_ = 10; UPDATE data_universe_ds2 SET DsExchMnem = 'XET', DsExchQtStartDate = '1999-06-18' WHERE SecCode = 56395 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 64757 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01' WHERE SecCode = 69724 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'AQYLON NEXUS LTD INR1 (POST SUBD)' WHERE SecCode = 72629 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 74558 AND Type_ = 10; UPDATE data_universe_ds2 SET DsSecDelistDate = '2008-10-29' WHERE SecCode = 76061 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 79236 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 80964 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 81821 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 82200 AND Type_ = 1; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 85031 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 87665 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 90015 AND Type_ = 1; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 90115 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 90117 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '2001-08-07', SecMapEndDate = '2079-06-06' WHERE SecCode = 90400 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 90416 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2003-02-03', SecMapEndDate = '2079-06-06' WHERE SecCode = 90729 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 91255 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2004-07-20', SecMapEndDate = '2079-06-06' WHERE SecCode = 91374 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 91937 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2005-06-15', SecMapEndDate = '2079-06-06' WHERE SecCode = 93182 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 93436 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2006-04-17', SecMapEndDate = '2079-06-06' WHERE SecCode = 93627 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 93662 AND Type_ = 1; UPDATE data_universe_ds2 SET Name = 'ENWAVE ENERGY CORP COM' WHERE SecCode = 93676 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 94209 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 94257 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2005-10-27', SecMapEndDate = '2079-06-06' WHERE SecCode = 94261 AND Type_ = 1; UPDATE data_universe_ds2 SET ISIN = NULL, Name = 'COSMO ADVANCED MAT KRW1000' WHERE SecCode = 94278 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '2002-05-03', SecMapEndDate = '2079-06-06' WHERE SecCode = 94313 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 95216 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 95309 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 95353 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 95653 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 95734 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2005-01-19', SecMapEndDate = '2079-06-06' WHERE SecCode = 95817 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 97041 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1998-07-22', SecMapEndDate = '2079-06-06' WHERE SecCode = 97570 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 97623 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 97858 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 98385 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 98466 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 98874 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 99035 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 99094 AND Type_ = 1; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-06', SecMapEndDate = '2026-03-05' WHERE SecCode = 99200 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 99697 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 101019 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 101048 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 101249 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 101493 AND Type_ = 1; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 115802 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 123540 AND Type_ = 1; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BDGS4B7' WHERE SecCode = 202343 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapStartDate = '2006-12-07', SecMapEndDate = '2079-06-06' WHERE SecCode = 216771 AND Type_ = 1; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 256226 AND Type_ = 10; UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 292047 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 313872 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2008-08-08', SecMapEndDate = '2079-06-06' WHERE SecCode = 367107 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapEndDate = '2013-02-14' WHERE SecCode = 376084 AND Type_ = 10; UPDATE data_universe_ds2 SET InfoCode = 301733, DsSecCode = 221611, IsMajorSec = 'N', DsCtryQtStatus = 'D', DsPrimQtSedol = 'BF29F59', DsSecDelistDate = '2017-11-29', DsExchQtStartDate = '2017-11-07', SecMapStartDate = '2026-03-05' WHERE SecCode = 703142 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 820885 AND Type_ = 10; UPDATE data_universe_ds2 SET InfoCode = 394019, DsSecCode = 271598, IsMajorSec = 'Y', DsSecDelistDate = '2016-02-23', DsExchQtStartDate = '2009-07-06', SecMapStartDate = '2009-07-06', SecMapEndDate = '2009-10-21' WHERE SecCode = 882295 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-06', SecMapEndDate = '2019-10-16' WHERE SecCode = 1019998 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-05', SecMapEndDate = '2023-12-08' WHERE SecCode = 1529243 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'B&M EURO VAL RE PL ORD GBP0.1', Country = 'JEY' WHERE SecCode = 2576985 AND Type_ = 10; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BP07NS4' WHERE SecCode = 2600875 AND Type_ = 10; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BDGS4B7' WHERE SecCode = 2653604 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'WHA PREMIUM GROWTH THB8.8678 (LOCAL)' WHERE SecCode = 2736320 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'WORLD DIGITAL ECO HKD0.02' WHERE SecCode = 2753942 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-03-05', SecMapEndDate = '2024-05-31' WHERE SecCode = 2879975 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2930562 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 2984547 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 3339559 AND Type_ = 10; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BV89NZ1' WHERE SecCode = 3347652 AND Type_ = 10; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BWTWT25' WHERE SecCode = 3430809 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 3441675 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'GLOBAL CHINESE BUS HKD0.01' WHERE SecCode = 3513957 AND Type_ = 10; UPDATE data_universe_ds2 SET ISIN = NULL, Name = 'AMIGO RES PLC ORD GBP0.0025' WHERE SecCode = 3536031 AND Type_ = 10; UPDATE data_universe_ds2 SET ISIN = NULL WHERE SecCode = 3629677 AND Type_ = 10; UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 4711624 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'EVERPURE INC BDR EACH 4 REPR 1 COM' WHERE SecCode = 4854787 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'SINOHEALTH TECH USD0.01' WHERE SecCode = 5082420 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'CYTECH GROUP CO LT CNY1' WHERE SecCode = 6159023 AND Type_ = 10; UPDATE data_universe_ds2 SET DsExchQtStartDate = '2025-05-23' WHERE SecCode = 6281753 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'VZAJEMNA ZDRAVSTVE NPV' WHERE SecCode = 6696786 AND Type_ = 10; UPDATE data_universe_ds2 SET Name = 'SKELETON COAST URANIUM CORP COM NEW' WHERE SecCode = 10922742 AND Type_ = 1; UPDATE data_universe_ds2 SET Name = 'RAPT THERAPEUTICS INC COM NEW' WHERE SecCode = 11198988 AND Type_ = 1; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BVCHP99' WHERE SecCode = 11236680 AND Type_ = 1; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BW47P38' WHERE SecCode = 11256200 AND Type_ = 1; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BVCHNR3' WHERE SecCode = 11260194 AND Type_ = 1; UPDATE data_universe_ds2 SET Name = 'PRESIDIO PRODTN CO CL A COM', Country = 'USA' WHERE SecCode = 11270085 AND Type_ = 1; UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BVCHPK0' WHERE SecCode = 11270239 AND Type_ = 1; UPDATE data_universe_ds2 SET SecMapStartDate = '2023-03-03' WHERE SecCode = 11285607 AND Type_ = 1; UPDATE data_universe_ds2 SET Name = 'SUNBELT RENTALS HOLDINGS INC SHS' WHERE SecCode = 11292663 AND Type_ = 1;