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: : 159805
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159805'
The Shares Amount is 7450000
The cusip is 61760E846
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '61760E846'
Number of Rows :5
update current13Fpositions set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271' ,
percentOut = '0.02'
where entryId = '51213802'
update current13Fpositions set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271' ,
percentOut = '1.64'
where entryId = '65085429'
update current13Fpositions set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271' ,
percentOut = '0'
where entryId = '80377762'
update current13Fpositions set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271' ,
percentOut = '2.01'
where entryId = '88897231'
update current13Fpositions set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271' ,
percentOut = '3.56'
where entryId = '89561067'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '61760E846'
Number of Rows :217
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '67829039'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '67705945'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66320881'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66046581'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68055109'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68123995'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '67369875'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '67987165'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66989834'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65327152'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '67898540'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66351696'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '67149100'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66706162'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66370382'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66135541'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66912260'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66898909'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68356146'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65912941'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65316248'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65356177'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65149060'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65123820'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '66387814'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65494718'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '63389973'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '63406551'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64210846'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64054132'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '63729213'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '63704076'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '65007253'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64164082'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64279468'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64591798'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64633159'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '63824478'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64378725'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64918821'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '64654879'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68430306'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68653435'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68770156'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69290604'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68443021'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69136668'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69811529'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69612450'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69226015'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '68422471'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69558054'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69401382'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '69592253'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '70825040'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '70234037'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '70498958'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '70491217'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '70726067'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71654295'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71248520'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71402928'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '70693762'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71628859'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71678954'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71608595'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71193494'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '71005730'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73705792'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '72486364'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '72456899'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '72184694'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '72754112'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73427499'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73682909'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73618700'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73645863'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73601072'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73591968'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73328341'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '73203118'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '72107045'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '74834907'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '74136808'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '74804282'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75495427'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '74792866'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75723760'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75249074'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75550692'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75473867'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75512933'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75457879'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75440375'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '75066207'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '74935389'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '76690448'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77562369'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '76060396'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '76881152'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '76259605'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77525012'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77010050'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77614228'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77318210'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '76208437'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77381371'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77621352'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77622623'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79238400'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '77990725'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '74325012'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '78099663'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '78026329'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79429552'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '78672862'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '78867199'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79218020'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79292788'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79634570'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79373569'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79832212'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '78190338'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '80906268'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81466978'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '80474172'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '80058744'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81134056'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '79884472'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '80579023'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81019395'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81046607'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81180895'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81352668'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81381263'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81479391'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81598886'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '82472638'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81838374'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '82428175'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83628060'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '82789414'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '82605346'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '81727097'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '82740852'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83073969'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83116052'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83207857'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83403459'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83440469'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83601695'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83629836'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83988854'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '83561549'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '84398527'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '84210610'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '84685286'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '84760196'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '84866525'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '85521397'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '85247607'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '85303031'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '85477211'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '86416460'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '85956784'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '86807686'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '86674726'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '86960408'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '87020208'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '87466700'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '87682587'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '89289029'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '88105902'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '88477061'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '89161021'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '89214899'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '90636196'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '90353993'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '90647929'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '90952631'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '91883360'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '91915648'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '92286968'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '93693866'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '93151175'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '93199776'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '51037810'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '94547674'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '94671784'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '95276801'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '94869178'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '95103671'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '95136660'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '95330899'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '95684711'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '96401122'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '96633348'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '96652021'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '96225575'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '96885241'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '97421489'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '97485845'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '97697455'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '97733141'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '98706670'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '99975359'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '100107203'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '99258754'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '99389313'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '100224215'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '100183587'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '100981148'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '101515706'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '102429045'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '102431091'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '102976704'
update archive13F set
compid = '159805',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004271'
where entryId = '103120976'
End Function
The Script is complete, exiting....