UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'IDOX.L^E26' WHERE SecCode = 4259 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AMWD.OQ^E26' WHERE SecCode = 5301 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CVGW.OQ^E26' WHERE SecCode = 11689 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ATSA.SN^E26' WHERE SecCode = 27223 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueOrder = 2, RkdListingType = NULL WHERE SecCode = 51554 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueOrder = 1, RkdListingType = 'OSR' WHERE SecCode = 51555 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'PTN.O', DisplayRIC = 'PTN.OQ', RkdExchCode = 'NASD' WHERE SecCode = 54177 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CH1548235246', SEDOL = 'BN4KLB', CUSIP = 'H8403Y11' WHERE SecCode = 66361 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US9750123039', Ticker = 'WNBDD', SEDOL = 'BW609C', CUSIP = '97501230', RIC = 'WNBDD.PK', DisplayRIC = 'WNBDD.PK' WHERE SecCode = 82248 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'AU000000BUY9', Ticker = 'BUY', SEDOL = '643769', CUSIP = 'Q1714E10', RIC = 'BUY.AX', DisplayRIC = 'BUY.AX' WHERE SecCode = 83612 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '1776.T^E26' WHERE SecCode = 89348 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SVI.BK^E26' WHERE SecCode = 95221 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 145838 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'DE000A41YEV7', Ticker = 'D6H0', SEDOL = 'BTHZM2', CUSIP = 'D194SZ12', RIC = 'D6H0n.DE', DisplayRIC = 'D6H0n.DE' WHERE SecCode = 161158 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 306979 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ELIJ.J^E26' WHERE SecCode = 320346 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 522760 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'TANH.BO', DisplayRIC = 'TANH.BO' WHERE SecCode = 555800 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, RIC = 'SDA.HNO', DisplayRIC = 'SDA.HNO', RkdExchCode = 'UPC' WHERE SecCode = 561036 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '4987.TWO^E26' WHERE SecCode = 887451 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000471450', Ticker = 'RANDA', SEDOL = 'BKVF42', RIC = 'RANDA.AX', DisplayRIC = 'RANDA.AX' WHERE SecCode = 3207868 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 3240133 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '4384.T^E26' WHERE SecCode = 3508359 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'H0743H12' WHERE SecCode = 4807494 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '5EA.AX^E26' WHERE SecCode = 4897803 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE0G1L01025', SEDOL = 'BX9GTG' WHERE SecCode = 4991509 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'KYG7802A1470', SEDOL = 'BWNNY2', CUSIP = 'G7802A14' WHERE SecCode = 5308047 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = '7827.TW', DisplayRIC = '7827.TW', RkdExchCode = 'TPE' WHERE SecCode = 6331607 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 6802675 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CNE100007NJ4', COATypeCode = 'IND' WHERE SecCode = 6806188 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA62958A1093', SEDOL = 'BW5VPW', CUSIP = '62958A10' WHERE SecCode = 10928316 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA0566002089', SEDOL = 'BW5VPT', CUSIP = '05660020' WHERE SecCode = 10964546 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'UI.H', RIC = 'UIh.V', DisplayRIC = 'UIh.V', RkdExchCode = 'NEX' WHERE SecCode = 11012221 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'NVG.CD^E26' WHERE SecCode = 11024302 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'RKTO', RIC = 'RKTO.O', DisplayRIC = 'RKTO.OQ' WHERE SecCode = 11193974 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG451391216', SEDOL = 'BTCD5P', CUSIP = 'G4513912' WHERE SecCode = 11204164 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'QH', RIC = 'QH.O', DisplayRIC = 'QH.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11209704 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG1281K1489', SEDOL = 'BW609L', CUSIP = 'G1281K14' WHERE SecCode = 11222298 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'TUNG.V', DisplayRIC = 'TUNG.V', RkdExchCode = 'CVE' WHERE SecCode = 11259074 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11274794 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'VGG7523E1218', SEDOL = 'BW5VP7', CUSIP = 'G7523E12' WHERE SecCode = 11286854 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'NXB', RIC = 'NXB', DisplayRIC = 'NXB.A' WHERE SecCode = 11288144 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11291142 AND Type_ = 1;