UPDATE data_universe_rkd SET Ticker = 'SONG', RIC = 'SONG.PK', DisplayRIC = 'SONG.PK' WHERE SecCode = 34417 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 69486 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = NULL, RIC = 'JTCMF.PK^B26', RkdExchCode = 'OTC', RkdExchCtry = 'USA' WHERE SecCode = 95709 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ADDVa.ST^B26' WHERE SecCode = 123563 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'CREP.BO', DisplayRIC = 'CREP.BO' WHERE SecCode = 130770 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 0.0, PrimaryIssueType = 'EQU' WHERE SecCode = 302758 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA1389095029', SEDOL = 'BWKC1M', CUSIP = '13890950' WHERE SecCode = 331595 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 482404 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'CEINSYS', RIC = 'CEIS.NS', DisplayRIC = 'CEIS.NS', RkdExchCode = 'NSE' WHERE SecCode = 2665928 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ADDVb.ST^B26' WHERE SecCode = 2981415 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'ES0105376059', SEDOL = 'BQXK3H', CUSIP = 'E0R03G14' WHERE SecCode = 3634524 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 4640279 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'INFIXPC1', RIC = 'INFIXPC1.LM', DisplayRIC = 'INFIXPC1.LM' WHERE SecCode = 4728985 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6590701 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6628665 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US65540B3033', SEDOL = 'BWKBDK', CUSIP = '65540B30' WHERE SecCode = 11078246 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA29391A1030', Ticker = 'EPG', SEDOL = 'BTJYJ8', CUSIP = '29391A10', RIC = 'EPG.CD', DisplayRIC = 'EPG.CD' WHERE SecCode = 11199074 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'AIAI.TO', DisplayRIC = 'AIAI.TO', RkdExchCode = 'TSE' WHERE SecCode = 11227131 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'SHAZ.O', DisplayRIC = 'SHAZ.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11235952 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'CNTN', RIC = 'CNTN.O', DisplayRIC = 'CNTN.OQ' WHERE SecCode = 11236954 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA3490243076', SEDOL = 'BWKC18', CUSIP = '34902430' WHERE SecCode = 11239425 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueOrder = 1, RkdListingType = 'ADR', ShPerListing = 1.0 WHERE SecCode = 11249579 AND Type_ = 1;