UPDATE data_universe_rkd SET Ticker = 'ALP', RIC = 'ALP.O', DisplayRIC = 'ALP.OQ' WHERE SecCode = 10042 AND Type_ = 1; UPDATE data_universe_rkd SET RkdListingType = 'OSR' WHERE SecCode = 27995 AND Type_ = 10; UPDATE data_universe_rkd SET RkdListingType = NULL WHERE SecCode = 28133 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'JLMC', RIC = 'JLMC.PK', DisplayRIC = 'JLMC.PK' WHERE SecCode = 37878 AND Type_ = 1; UPDATE data_universe_rkd SET RkdListingType = 'OSR' WHERE SecCode = 51313 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'BRWY.SI^D26' WHERE SecCode = 70971 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'CUBT', RIC = 'CUBT.PK', DisplayRIC = 'CUBT.PK' WHERE SecCode = 72759 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7739.T^D26' WHERE SecCode = 73311 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CAU.L^D26' WHERE SecCode = 111378 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'XINRY', SEDOL = 'BP5J9J', RIC = 'XINRY.PK', DisplayRIC = 'XINRY.PK', RkdExchCode = 'OTC' WHERE SecCode = 334399 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU000000WWI4', Ticker = 'WWI', SEDOL = 'B2B2J5', CUSIP = 'Q9762L17', RIC = 'WWI.AX', DisplayRIC = 'WWI.AX' WHERE SecCode = 347684 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SCT.AX^D26' WHERE SecCode = 3387565 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 3402869 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 3444707 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000459778', Ticker = 'HXLDB', SEDOL = 'BV5LSJ', RIC = 'HXLDB.AX', DisplayRIC = 'HXLDB.AX' WHERE SecCode = 4427868 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'LABS.L^D26' WHERE SecCode = 4777328 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '452670.KQ^D26' WHERE SecCode = 5525173 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007KS1' WHERE SecCode = 6737826 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007KT9' WHERE SecCode = 6752844 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007KV5' WHERE SecCode = 6755591 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y0980910' WHERE SecCode = 6772978 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007KW3' WHERE SecCode = 6773037 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y257R810', COATypeCode = 'IND' WHERE SecCode = 6782575 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007KX1' WHERE SecCode = 6786375 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 10928401 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'LYXX', RIC = 'LYXX.PK', DisplayRIC = 'LYXX.PK' WHERE SecCode = 11149414 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA3978841078', Ticker = 'GREY', SEDOL = 'BQXPK2', CUSIP = '39788410', RIC = 'GREY.CD', DisplayRIC = 'GREY.CD' WHERE SecCode = 11156632 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'SOHOB.PK', DisplayRIC = 'SOHOB.PK', RkdExchCode = 'OTC' WHERE SecCode = 11161916 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'BRLL', RIC = 'BRLL.PK', DisplayRIC = 'BRLL.PK' WHERE SecCode = 11173258 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = NULL, RIC = 'SOHOO.PK', DisplayRIC = 'SOHOO.PK', RkdExchCode = 'OTC' WHERE SecCode = 11177805 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'SOHON.PK', DisplayRIC = 'SOHON.PK', RkdExchCode = 'OTC' WHERE SecCode = 11195911 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BWFJDH', RIC = 'KEEL.O', DisplayRIC = 'KEEL.OQ', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11198774 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US63911H4056', SEDOL = 'BRWG61', CUSIP = '63911H40' WHERE SecCode = 11228244 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US98980W2061', SEDOL = 'BRWG63', CUSIP = '98980W20' WHERE SecCode = 11272365 AND Type_ = 1;