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: : 152081
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '152081'
The Shares Amount is 1300000
The cusip is 97717W810
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '97717W810'
Number of Rows :13
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '0.77'
where entryId = '14879539'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '132.71'
where entryId = '17208739'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '534.63'
where entryId = '23179596'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '2.31'
where entryId = '35074324'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '1.25'
where entryId = '42168245'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '0.88'
where entryId = '42194394'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '0'
where entryId = '42265018'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '0'
where entryId = '42685403'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '31.67'
where entryId = '51218184'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '55.47'
where entryId = '53430482'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '1.54'
where entryId = '60995374'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '25.28'
where entryId = '62203903'
update current13Fpositions set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416' ,
percentOut = '0.06'
where entryId = '80338783'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '97717W810'
Number of Rows :168
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '68174147'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '67710410'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '68006254'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66590486'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66836728'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65671826'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '67246911'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '67367447'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66997190'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '68056026'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '67880155'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66466268'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '67837810'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '68330105'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66375036'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65852829'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66352901'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64557974'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65449382'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66055182'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66321745'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '68086771'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '67274447'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66590311'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '67784601'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65748598'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66570443'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65313165'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '66080718'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65663798'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65363472'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65377219'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '65950871'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '63384319'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64647501'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '63736078'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '63498168'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '63967199'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64007940'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '63582531'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64176729'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64979101'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64288439'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '63804116'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64612610'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64592660'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64634412'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64383552'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64342868'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64740146'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '64659328'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '68449506'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69184052'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '68822266'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69144427'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69243883'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69820754'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69610633'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69275036'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69558874'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69593443'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69512944'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69383933'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '69686551'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '70120354'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '70691844'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '70733935'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '70773734'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71352193'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71614531'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71403733'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71680129'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71592207'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71198074'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71810716'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71014462'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '71396833'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '72760334'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '72102052'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '72494390'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73407013'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73096033'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '72745468'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '72532405'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73607065'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73429001'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73647124'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73593128'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73333040'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73212124'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73504370'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '72559087'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73987039'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '74144578'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '74851661'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '74227290'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '73906544'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '74845355'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75723786'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75592433'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75250064'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75623614'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75096221'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75441582'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '74874254'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75070867'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '74944469'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75241320'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '75036193'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '76028323'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77532573'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '76067864'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '76749745'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77038131'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77624384'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77454842'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '76889957'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77014634'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77483238'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77382124'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77047357'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77622571'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '77998565'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '74325038'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '78033815'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '78393704'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '78675814'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '79540874'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '78871790'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '78891996'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '79197767'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '79293611'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '79315309'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '79643807'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '79374847'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '78190362'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '80953621'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '80481138'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81504149'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81166890'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81022397'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81054378'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81183540'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81336645'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81382141'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81406920'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '80579581'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81600169'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '81838505'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83628781'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83550207'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '82605430'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83077052'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83570566'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83576626'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83597101'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83596341'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83630131'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '83591580'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '84688496'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '86963731'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '89164463'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '90956142'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '93843738'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '51038811'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '43898327'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '96634340'
update archive13F set
compid = '152081',
sectorNum = '302003',
sectorDes = 'Closed - End Fund - Equity',
issuerCik = '9000000416'
where entryId = '97563662'
End Function
The Script is complete, exiting....