UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US30233Q1085', SEDOL = 'BVSRPD', CUSIP = '30233Q10' WHERE SecCode = 25075 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 40231 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ZWM.S^F26' WHERE SecCode = 49597 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '032980.KQ^G26' WHERE SecCode = 72952 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '8048.HK^F26' WHERE SecCode = 76126 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA60365B1085', SEDOL = 'BWXHXK', CUSIP = '60365B10' WHERE SecCode = 80076 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'JHG.N^G26' WHERE SecCode = 84357 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 100020 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'RAK.NZ^E26' WHERE SecCode = 145065 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GOCH.PK^G26' WHERE SecCode = 317753 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '101390.KQ^G26' WHERE SecCode = 409378 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GFC.TA^F26' WHERE SecCode = 1025098 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '106520.KQ^G26' WHERE SecCode = 1622819 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3681.T^G26' WHERE SecCode = 2394793 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '230360.KQ^F26' WHERE SecCode = 3217845 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '227100.KQ^G26' WHERE SecCode = 3663157 AND Type_ = 10; UPDATE data_universe_rkd SET RkdCode = 144914, RkdIssueCode = 185379, COATypeCode = '' WHERE SecCode = 3961764 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'MDH.L', DisplayRIC = 'MDH.L', RkdExchCode = 'LON' WHERE SecCode = 4633023 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = '293A.T', DisplayRIC = '293A.T', RkdExchCode = 'TYO' WHERE SecCode = 6043600 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6832528 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6927587 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6934738 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y734D110' WHERE SecCode = 6948297 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y5278110' WHERE SecCode = 6951857 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HLCO.PK^F26' WHERE SecCode = 10902674 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SEM.N^G26' WHERE SecCode = 10922117 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 0.33333 WHERE SecCode = 10971738 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BLD.N^G26' WHERE SecCode = 11149443 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'STEL.N^G26' WHERE SecCode = 11178625 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SILA.N^G26' WHERE SecCode = 11201264 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA39788G1000', SEDOL = 'BWXHXH', CUSIP = '39788G10' WHERE SecCode = 11225847 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'CIRC', RIC = 'CIRC.O', DisplayRIC = 'CIRC.OQ' WHERE SecCode = 11229331 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'HODO', RIC = 'HODO.O', DisplayRIC = 'HODO.OQ' WHERE SecCode = 11275764 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 11290704 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295148 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11297836 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'MBGL', RIC = 'MBGL.K', DisplayRIC = 'MBGL.N' WHERE SecCode = 11298320 AND Type_ = 1;