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: : 142434
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142434'
The Shares Amount is 90000000
The cusip is 922908108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '922908108'
Number of Rows :26
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.39'
where entryId = '11055240'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.35'
where entryId = '11275307'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '10.36'
where entryId = '12256024'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.38'
where entryId = '12911088'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.02'
where entryId = '13627819'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.06'
where entryId = '13628261'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0'
where entryId = '14233850'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.38'
where entryId = '14629034'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.37'
where entryId = '16060984'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.75'
where entryId = '16513280'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.4'
where entryId = '16670272'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.63'
where entryId = '16838231'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.37'
where entryId = '17483274'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.71'
where entryId = '18239455'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.4'
where entryId = '18386454'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.38'
where entryId = '42073838'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.18'
where entryId = '42081652'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '1.21'
where entryId = '42113991'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.27'
where entryId = '42183712'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.2'
where entryId = '42234863'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.75'
where entryId = '42236646'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0'
where entryId = '42265386'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.13'
where entryId = '75991364'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.43'
where entryId = '85034431'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0.19'
where entryId = '71165537'
update current13Fpositions set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022' ,
percentOut = '0'
where entryId = '87617257'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '922908108'
Number of Rows :239
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66867003'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66942631'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68291564'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68333523'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67172921'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67266387'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67043522'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65027059'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67428971'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68114516'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68364318'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65195934'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '62488687'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67465051'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66655013'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67287405'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67520274'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67276799'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66749094'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67601749'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67036017'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66674444'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66867427'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67448857'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67523976'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66791387'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67206597'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65843605'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65592688'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65572612'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65901027'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65025026'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '66242650'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65455995'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65152423'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65696108'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65290522'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65422076'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65043885'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65089171'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65229059'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65221568'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '65029918'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63362868'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63422590'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63428268'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63441989'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63548232'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63551193'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63553985'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63645123'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63672557'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63661000'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '64781507'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '64064511'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63985658'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63767083'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '63896043'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '64494420'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '64916976'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '64250929'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68441878'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68501220'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '69949111'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68603252'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68734937'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68720896'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68592181'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68469765'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '67500086'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68698920'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '69042527'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '68908293'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70014737'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '69331509'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70037203'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70012995'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70015397'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '69218432'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '69892216'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70140153'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70917786'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70146443'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70416968'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70417088'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70448980'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70297930'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70145413'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70547830'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70243127'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70515475'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70540200'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '71556135'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '69431656'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '70819980'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '71367349'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '71776581'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '71355951'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72924585'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72144533'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72691592'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '71977955'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72147983'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72267714'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72241883'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72268048'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72287012'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72915792'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72392515'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72235052'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72145491'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '72320547'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73002250'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73405384'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73034863'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73812088'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73822826'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73838600'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73937488'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74264565'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74005086'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74017486'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73960871'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74157674'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74037416'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75210224'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74164517'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74185944'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74025575'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '73877695'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75429770'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '74343382'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75199623'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75398958'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76080277'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75746368'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75763421'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75874100'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76378726'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '75943719'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76429533'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76735677'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76348163'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76566204'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76189201'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77267331'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77151184'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '76639577'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77276423'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77553326'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77842229'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77686396'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77683490'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77705734'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '78278892'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79520348'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '78072254'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77885859'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '78094849'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '78429818'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '78470971'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '77931424'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79262210'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79588514'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79041850'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79160678'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79589627'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79717622'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79781733'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79684694'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80182886'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79984010'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80045236'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79804754'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80013775'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80426414'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80240956'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80222705'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81248977'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81314143'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79725223'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '79846460'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80836670'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81794984'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '80935290'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81666254'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81670460'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81689813'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81743150'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81857356'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81879165'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '82106975'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83474660'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '82026466'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83669387'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '82078683'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '81879523'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '82813595'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '82880309'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83530821'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83161493'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83414475'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83846891'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '82164453'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83811982'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83741702'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83964088'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83692957'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83741355'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83698510'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '84947721'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83950093'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83900384'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83904682'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '84034115'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '83679042'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '84455918'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '84802791'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '84591751'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '85164707'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '85283216'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '85771869'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '85969042'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '85961297'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '85965360'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '86091819'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '85968596'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '86296531'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '86295954'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '86007512'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '86640010'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '86638518'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '87627514'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '87668187'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '87678916'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '87639652'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '88290849'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '90023235'
update archive13F set
compid = '142434',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000022'
where entryId = '92364725'
End Function
The Script is complete, exiting....