To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 130824
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130824'
The Shares Amount is 196944000
The cusip is 14055X102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '14055X102'
Number of Rows :164
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.19'
where entryId = '1264271'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '1827196'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '35.8'
where entryId = '2414967'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '11.59'
where entryId = '2827515'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.56'
where entryId = '3503845'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1'
where entryId = '3727099'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.22'
where entryId = '3916566'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '6.18'
where entryId = '6878988'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.28'
where entryId = '7429539'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.73'
where entryId = '9341030'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '6.56'
where entryId = '9753822'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '76.05'
where entryId = '10230111'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '6.25'
where entryId = '10595626'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.86'
where entryId = '11042182'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '44.24'
where entryId = '11093614'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '11115549'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '13.58'
where entryId = '11118743'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.69'
where entryId = '11369384'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '4.74'
where entryId = '11464432'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '7.82'
where entryId = '12083530'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '37.12'
where entryId = '12318125'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '260.11'
where entryId = '12389372'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.75'
where entryId = '12539305'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '10.29'
where entryId = '12723219'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.99'
where entryId = '12850229'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.68'
where entryId = '12895679'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.02'
where entryId = '12933965'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.65'
where entryId = '12992250'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '105.18'
where entryId = '13020775'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.64'
where entryId = '13022507'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.95'
where entryId = '13242423'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.28'
where entryId = '13243720'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.49'
where entryId = '13717647'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.02'
where entryId = '13784483'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.65'
where entryId = '13902383'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '37.35'
where entryId = '13937457'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '148.98'
where entryId = '14098649'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '3.54'
where entryId = '14299625'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.68'
where entryId = '14309747'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '96.58'
where entryId = '14355497'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.56'
where entryId = '14582851'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '87.52'
where entryId = '14676608'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.76'
where entryId = '14677675'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.25'
where entryId = '14870127'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '44.88'
where entryId = '14872658'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '138.82'
where entryId = '15160229'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.86'
where entryId = '15161729'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '38.51'
where entryId = '15257753'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '15262980'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '8.43'
where entryId = '15455176'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.08'
where entryId = '15455388'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.65'
where entryId = '15609945'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '3.18'
where entryId = '15876258'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.51'
where entryId = '15997757'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '218.88'
where entryId = '16050030'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '89.69'
where entryId = '16192333'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.64'
where entryId = '16193908'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.52'
where entryId = '16352734'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.52'
where entryId = '16353988'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.53'
where entryId = '16566892'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.05'
where entryId = '16610295'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.07'
where entryId = '16709050'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '39.98'
where entryId = '16762715'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.38'
where entryId = '16776291'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '148.59'
where entryId = '16884986'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.02'
where entryId = '16938186'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.59'
where entryId = '16961182'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.53'
where entryId = '17012248'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '17012934'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.08'
where entryId = '17051481'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.65'
where entryId = '17066757'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '17073891'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '26.33'
where entryId = '17097667'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '17105064'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '10.19'
where entryId = '17135129'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '76.09'
where entryId = '17191158'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '29.7'
where entryId = '17196237'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '19.7'
where entryId = '17274624'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.72'
where entryId = '17350226'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '61.44'
where entryId = '17536922'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '17787022'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '4.57'
where entryId = '17966799'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '3.21'
where entryId = '17977564'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.55'
where entryId = '18066753'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.03'
where entryId = '18067227'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.12'
where entryId = '18115882'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '44.63'
where entryId = '18180787'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.13'
where entryId = '18265625'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '18273431'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '218.12'
where entryId = '18276415'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '18355342'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.83'
where entryId = '18385734'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1'
where entryId = '18540195'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.65'
where entryId = '18545469'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '18.63'
where entryId = '18548779'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '207.36'
where entryId = '18650592'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '18658876'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '105.88'
where entryId = '18695536'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '5.76'
where entryId = '18761348'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '3.93'
where entryId = '18783587'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.51'
where entryId = '18805561'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '19027093'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.51'
where entryId = '19052636'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.87'
where entryId = '19147350'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '5.78'
where entryId = '19263814'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '7.06'
where entryId = '19884521'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.65'
where entryId = '20110250'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '61.32'
where entryId = '20286618'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.65'
where entryId = '21464653'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '3.66'
where entryId = '23168831'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '5.08'
where entryId = '23677117'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.17'
where entryId = '23809545'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.17'
where entryId = '24138103'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '24519580'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '24921679'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '24928360'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '26164091'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.08'
where entryId = '26773593'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.04'
where entryId = '28779072'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '31252645'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.13'
where entryId = '31290825'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '42.35'
where entryId = '31798893'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '111.1'
where entryId = '34859358'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '36600031'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.91'
where entryId = '37276633'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.68'
where entryId = '38353406'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.63'
where entryId = '38467021'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '3.24'
where entryId = '39309211'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.01'
where entryId = '40630602'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.08'
where entryId = '42070950'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '121.12'
where entryId = '42089673'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '17.35'
where entryId = '42105278'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '29.45'
where entryId = '42118044'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.25'
where entryId = '42119643'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.01'
where entryId = '42133521'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.59'
where entryId = '42139229'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.26'
where entryId = '42143580'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.03'
where entryId = '42145332'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '2.96'
where entryId = '42148724'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.56'
where entryId = '42153324'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '17.87'
where entryId = '42155125'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '7.82'
where entryId = '42171492'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.17'
where entryId = '42181034'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '32.63'
where entryId = '42183385'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '19.22'
where entryId = '42195634'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.03'
where entryId = '42198157'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '215.81'
where entryId = '42215520'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.28'
where entryId = '42224094'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '5.44'
where entryId = '42228543'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '344.44'
where entryId = '42234462'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.06'
where entryId = '42239823'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '42265578'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '42267024'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '42466776'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '42470733'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '1.71'
where entryId = '42497674'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.42'
where entryId = '43980020'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '37.04'
where entryId = '44142026'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0.06'
where entryId = '44309424'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '44620391'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '41.88'
where entryId = '46539559'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '5.08'
where entryId = '46669279'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '47624185'
update current13Fpositions set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199' ,
percentOut = '0'
where entryId = '49517163'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '14055X102'
Number of Rows :4
update archive13F set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199'
where entryId = '47197886'
update archive13F set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199'
where entryId = '67780815'
update archive13F set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199'
where entryId = '65271867'
update archive13F set
compid = '130824',
sectorNum = '302005',
sectorDes = 'Credit Services',
issuerCik = '0001241199'
where entryId = '46160322'
End Function
The Script is complete, exiting....