UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'CDIX', RIC = 'CDIX.PK', DisplayRIC = 'CDIX.PK' WHERE SecCode = 12361 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'P5R05211' WHERE SecCode = 28224 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US7658162026', Ticker = 'RDGAD', SEDOL = 'BVPBPJ', CUSIP = '76581620', RIC = 'RDGAD.PK', DisplayRIC = 'RDGAD.PK' WHERE SecCode = 60019 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'LUZC', RIC = 'LUZC.TA', DisplayRIC = 'LUZC.TA' WHERE SecCode = 76940 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6312.T^A26' WHERE SecCode = 80118 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TGP.AX^B26' WHERE SecCode = 137813 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'KDV', RIC = 'KDV.ST', DisplayRIC = 'KDV.ST' WHERE SecCode = 1108989 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 1638702 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'IL0012165630', SEDOL = 'BP4YTP', CUSIP = 'M8T80P20', RIC = 'NEXN.O', DisplayRIC = 'NEXN.OQ', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 2566755 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CLAB.TA^B26' WHERE SecCode = 4510247 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 4707129 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '9956.HK^B26' WHERE SecCode = 4767831 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 5288740 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '456490.KQ^B26' WHERE SecCode = 5462279 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6596120 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6605910 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6626594 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007GZ4' WHERE SecCode = 6638308 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA84841L5062', SEDOL = 'BVLNJT', CUSIP = '84841L50' WHERE SecCode = 10968580 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'SNBH', RIC = 'SNBH.PK', DisplayRIC = 'SNBH.PK' WHERE SecCode = 10970935 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11002303 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US0083893067', SEDOL = 'BVLNNH', CUSIP = '00838930' WHERE SecCode = 11190100 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TRBR.V^B26' WHERE SecCode = 11193662 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GBIO.OQ^B26' WHERE SecCode = 11208758 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = NULL, Ticker = NULL, SEDOL = NULL, CUSIP = NULL, RIC = NULL, DisplayRIC = NULL, RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 11225824 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US42227W4050', SEDOL = 'BVLNNG', CUSIP = '42227W40' WHERE SecCode = 11231550 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'MLM.NLB', DisplayRIC = 'MLM.NLB', RkdExchCode = 'NLB' WHERE SecCode = 11241337 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'STAI.PK', DisplayRIC = 'STAI.PK', RkdExchCode = 'OTC' WHERE SecCode = 11250357 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'VGG3662E1218', SEDOL = 'BVLNK8', CUSIP = 'G3662E12' WHERE SecCode = 11270868 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'G3221211' WHERE SecCode = 11277491 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11290726 AND Type_ = 1;