UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'FRGT.L^B26' WHERE SecCode = 7679 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'BCHT.K', DisplayRIC = 'BCHT.A', RkdExchCode = 'ASE' WHERE SecCode = 19896 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'CASIF', RIC = 'CASIF.PK', DisplayRIC = 'CASIF.PK', RkdExchCode = 'OTC' WHERE SecCode = 24123 AND Type_ = 1; UPDATE data_universe_rkd SET RkdListingType = 'OSR', ISIN = NULL, Ticker = NULL, SEDOL = NULL, CUSIP = NULL, RIC = NULL, DisplayRIC = NULL, RkdExchCode = 'NA', RkdExchCtry = NULL, PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 30746 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL WHERE SecCode = 44097 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3526.T^B26' WHERE SecCode = 68739 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = NULL WHERE SecCode = 70634 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL WHERE SecCode = 79190 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PRE' WHERE SecCode = 82349 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PRE' WHERE SecCode = 82350 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PRE' WHERE SecCode = 82351 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PRE' WHERE SecCode = 82352 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PRE' WHERE SecCode = 82355 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9600.T^B26' WHERE SecCode = 84504 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7445.T^B26' WHERE SecCode = 94026 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU0000452112', Ticker = 'PGYDF', SEDOL = 'BRBTLN', RIC = 'PGYDF.AX', DisplayRIC = 'PGYDF.AX' WHERE SecCode = 142703 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'FORG', RIC = 'FORG.L', DisplayRIC = 'FORG.L' WHERE SecCode = 431791 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TS4.HNO^B26' WHERE SecCode = 522879 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ALAVE.PA^B26' WHERE SecCode = 2461937 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'STATE', RIC = 'STATE.NGM', DisplayRIC = 'STATE.NGM' WHERE SecCode = 3198246 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 3282920 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '2448.HK^B26' WHERE SecCode = 3429659 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 4041272 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3036A.TW^B26' WHERE SecCode = 4338890 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'INE732I01021', SEDOL = 'BRBTVP', CUSIP = 'Y0S1DZ11' WHERE SecCode = 4375171 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET RkdListingType = NULL, COATypeCode = 'IND' WHERE SecCode = 6645629 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'NXTS', RIC = 'NXTS.O', DisplayRIC = 'NXTS.OQ' WHERE SecCode = 10925121 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'ATVK', RIC = 'ATVK.PK', DisplayRIC = 'ATVK.PK' WHERE SecCode = 11039346 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'RNAM', RIC = 'RNAM.O', DisplayRIC = 'RNAM.OQ' WHERE SecCode = 11208743 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'AGMR.TO', DisplayRIC = 'AGMR.TO', RkdExchCode = 'TSE' WHERE SecCode = 11237926 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'CA45791Q1000', SEDOL = 'BSRFKM', CUSIP = '45791Q10' WHERE SecCode = 11266644 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11291180 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11291397 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'QADRU.O' WHERE SecCode = 11291637 AND Type_ = 1;