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: : 130763
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130763'
The Shares Amount is 7502000
The cusip is 900145103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '900145103'
Number of Rows :31
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '11.46'
where entryId = '2608458'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0'
where entryId = '3507306'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0.9'
where entryId = '9757615'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '38.66'
where entryId = '10453748'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '126.55'
where entryId = '12305123'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0.37'
where entryId = '13025366'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0.37'
where entryId = '14680492'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0.83'
where entryId = '14878913'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '315.51'
where entryId = '16639279'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '14.16'
where entryId = '17427014'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '41.56'
where entryId = '18299490'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0'
where entryId = '18552001'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '273.81'
where entryId = '18669393'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '93.05'
where entryId = '20169148'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '6.71'
where entryId = '23159811'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '74.2'
where entryId = '23178631'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0'
where entryId = '24522779'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0'
where entryId = '29312349'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0'
where entryId = '34311611'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '3.53'
where entryId = '37278395'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '14'
where entryId = '40368916'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '99.55'
where entryId = '42068021'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '78.77'
where entryId = '42078140'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '64.97'
where entryId = '42172557'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '40.12'
where entryId = '42184710'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '0'
where entryId = '42470287'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '2.05'
where entryId = '51217402'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '596.68'
where entryId = '57311195'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '13.33'
where entryId = '62417484'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '5.6'
where entryId = '64677864'
update current13Fpositions set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218' ,
percentOut = '7.21'
where entryId = '65083981'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '900145103'
Number of Rows :157
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66396342'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66313384'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67996402'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67835795'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68204348'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67601475'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67176639'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66590913'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67709430'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67602379'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67773442'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68336773'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67176701'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65367814'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67906090'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66092439'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66974783'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67507106'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68127903'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68329871'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67314127'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66788458'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67251817'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68165606'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67590805'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67682627'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67692902'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68110338'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68329455'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66722230'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67515056'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65330918'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67963766'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66995524'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65499547'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67176748'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65908961'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65901342'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67867984'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66173065'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65900405'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66283503'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67923748'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65972536'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67112914'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66053201'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66344117'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65671498'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65865299'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66296133'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65361844'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65432424'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65659947'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65178479'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65120887'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66591151'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65312875'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65368213'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '65570139'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63388493'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63821319'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63884920'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63884505'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64057880'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63734521'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64013526'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64994059'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63749634'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63858783'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63528687'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64007196'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64611943'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64120026'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '63674261'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64472339'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64460926'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64286396'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64582638'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64426073'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64677376'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64331049'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64730445'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '64658329'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68489418'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '66836532'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70191420'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69872718'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69349869'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69294577'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68948469'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69142679'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69250158'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '68559876'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69758524'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69818684'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69907708'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69112544'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69610612'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69409705'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69227233'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69584263'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69550780'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69502399'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69430679'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69475878'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69916506'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69353771'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69745398'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69372141'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69677127'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '67641229'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70100088'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70191532'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71739674'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70732164'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70823184'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '69082490'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73750594'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70308291'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70828488'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70959781'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71596779'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71581782'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71434167'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71777555'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71345466'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71211691'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71560274'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71071519'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '70695164'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71451053'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71197056'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71423335'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71012429'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '71387927'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '72802868'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '72731616'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '72370997'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73110577'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '72107736'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73117303'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73712689'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73127116'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73714553'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73115940'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73718241'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73725161'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73728189'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73729977'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73806348'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73748306'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73749273'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73749670'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '73748621'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '74343896'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '51038617'
update archive13F set
compid = '130763',
sectorNum = '302004',
sectorDes = 'Closed - End Fund - Foreign',
issuerCik = '0000856218'
where entryId = '96634148'
End Function
The Script is complete, exiting....