UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'VISK', RIC = 'VISK.PK', DisplayRIC = 'VISK.PK' WHERE SecCode = 24143 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'BCB.AX^G26' WHERE SecCode = 68818 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA6076773093', SEDOL = 'BXL2FB', CUSIP = '60767730' WHERE SecCode = 99582 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 134942 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'US48214U1043', SEDOL = 'BXL2C4', CUSIP = '48214U10' WHERE SecCode = 336830 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BXP2X4' WHERE SecCode = 353611 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'ABBEYBANK', RIC = 'ABBEYBANK.LG', DisplayRIC = 'ABBEYBANK.LG' WHERE SecCode = 433151 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, SEDOL = NULL, RIC = 'ABSO.MOT^G26', DisplayRIC = 'ABSO.MOT^G26' WHERE SecCode = 1464837 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'QRTP.WA^G26' WHERE SecCode = 1485705 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'KYG4417G1148', SEDOL = 'BTNP4P', CUSIP = 'G4417G11' WHERE SecCode = 6456244 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 7009117 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'ADTX.PK', DisplayRIC = 'ADTX.PK', RkdExchCode = 'OTC' WHERE SecCode = 11207780 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US3207035078', SEDOL = 'BT3L2N', CUSIP = '32070350' WHERE SecCode = 11233010 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BXP2W2' WHERE SecCode = 11240122 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'M6147216' WHERE SecCode = 11245088 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'IWIN.CD^G26' WHERE SecCode = 11245822 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 8.0 WHERE SecCode = 11249579 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'APO_pa.N^G26' WHERE SecCode = 11256233 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US9887402058', SEDOL = 'BXRVP0', CUSIP = '98874020', ShPerListing = 30.0 WHERE SecCode = 11268474 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG9876W1380', SEDOL = 'BVCK9N', CUSIP = 'G9876W13' WHERE SecCode = 11273379 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US18912E3062', SEDOL = 'BXL29L', CUSIP = '18912E30' WHERE SecCode = 11274459 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG6713S1140', SEDOL = 'BXL2B2', CUSIP = 'G6713S11' WHERE SecCode = 11278479 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG812371360', SEDOL = 'BTMQZD', CUSIP = 'G8123713' WHERE SecCode = 11281418 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11297676 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11298232 AND Type_ = 1;