UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AQIS.PK^C26' WHERE SecCode = 6150 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MERC4.SA^C26' WHERE SecCode = 29843 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'QMED.PK^C26' WHERE SecCode = 58561 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'WITH.HE^C26' WHERE SecCode = 62226 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ZYXIQ.PK^C26' WHERE SecCode = 83159 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '1841.T^C26' WHERE SecCode = 94697 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'LU3306723589', SEDOL = 'BV4K98', CUSIP = 'L5S2AP10' WHERE SecCode = 95711 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7923.T^C26' WHERE SecCode = 97746 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3454.TW^C26' WHERE SecCode = 132380 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE1LKO01015', SEDOL = 'BWTZ1Z', CUSIP = 'Y1R49B10' WHERE SecCode = 136022 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'TSGO', RIC = 'TSGO.PK', DisplayRIC = 'TSGO.PK' WHERE SecCode = 306890 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'LANM.SI', DisplayRIC = 'LANM.SI' WHERE SecCode = 340262 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US44984F8804', SEDOL = 'BTZS1M', CUSIP = '44984F88' WHERE SecCode = 354777 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '002231.SZ^C26' WHERE SecCode = 380600 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y270NR10' WHERE SecCode = 1123551 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, RIC = 'INDC.BO' WHERE SecCode = 1513718 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 1666188 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y6337E10' WHERE SecCode = 2536101 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'SCPKR', RIC = 'SCPKR.MC', DisplayRIC = 'SCPKR.MC' WHERE SecCode = 3738156 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 4339150 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'GB00BSHRN331', Ticker = 'COIL', SEDOL = 'BSHRN3', CUSIP = 'G7636D10', RIC = 'COIL.L', DisplayRIC = 'COIL.L' WHERE SecCode = 4539312 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE0NQ401024', SEDOL = 'BW43D0', CUSIP = 'Y048FE12' WHERE SecCode = 6075860 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y3R80Z11' WHERE SecCode = 6645649 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y2S47A10' WHERE SecCode = 6645655 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6731964 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 11181011 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'CMBMF', RIC = 'CMBMF.PK', DisplayRIC = 'CMBMF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11198280 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US00791N2018', SEDOL = 'BTZS1P', CUSIP = '00791N20' WHERE SecCode = 11200200 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = NULL, RIC = 'NOTE.PK', DisplayRIC = 'NOTE.PK', RkdExchCode = 'OTC' WHERE SecCode = 11215481 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US2437335084', SEDOL = 'BTZS29', CUSIP = '24373350' WHERE SecCode = 11234992 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US20678X5023', SEDOL = 'BTZS24', CUSIP = '20678X50' WHERE SecCode = 11240122 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TBMC.OQ^C26' WHERE SecCode = 11252862 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG5480M1107', SEDOL = 'BTTMLQ', CUSIP = 'G5480M11' WHERE SecCode = 11270869 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA6279311089', SEDOL = 'BTG0PM', CUSIP = '62793110' WHERE SecCode = 11274307 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CHAC.OQ^C26' WHERE SecCode = 11278379 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11293659 AND Type_ = 1;