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: : 159575
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159575'
The Shares Amount is 12090000000
The cusip is Y002A1105
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'Y002A1105'
Number of Rows :7
update current13Fpositions set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041' ,
percentOut = '0.9'
where entryId = '42076749'
update current13Fpositions set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041' ,
percentOut = '0'
where entryId = '100065051'
update current13Fpositions set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041' ,
percentOut = '0.03'
where entryId = '68942331'
update current13Fpositions set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041' ,
percentOut = '5.77'
where entryId = '132167589'
update current13Fpositions set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041' ,
percentOut = '0'
where entryId = '123075404'
update current13Fpositions set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041' ,
percentOut = '0.02'
where entryId = '130102818'
update current13Fpositions set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041' ,
percentOut = '2.26'
where entryId = '129943536'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'Y002A1105'
Number of Rows :243
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '66213266'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '67951331'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '66799051'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '67063574'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '67652139'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '67212678'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '67282412'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '66874004'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '66915635'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '67480822'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '67177160'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '66535482'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '65718122'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '65261579'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '65872446'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '65172926'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '65285606'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '65916504'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '65255227'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '63621138'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '63558521'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '63682358'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '63369827'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '63957602'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '64978591'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '64975130'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '64816621'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '64464027'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '68402393'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '68549707'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '68725093'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '68693973'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '69863353'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '69949154'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '69964420'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '69467291'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '69508328'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '70119748'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '70072062'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '70150505'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '70209367'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '70287088'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '71593842'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '71468912'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '71165570'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '71164846'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '71202117'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '71153702'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '71996112'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '72062461'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '72313193'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '72798381'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '72731647'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '72236312'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '73513095'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '73339939'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '73340079'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '73345354'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '73747585'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '73940183'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '74042359'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '74045453'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '74450776'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '73961127'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '74061624'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75309644'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75049178'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75048934'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75115544'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75748141'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75984191'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75938066'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '76747419'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '75787604'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '76189272'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '77060589'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '76972463'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '77047518'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '77171582'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '77033426'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '77928254'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '77688084'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '78208289'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '77878879'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '78471037'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '79492454'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '78845736'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '78930746'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '79069757'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '79554791'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '79907134'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '79789573'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '80240452'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '79719687'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '79907422'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '81264224'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '81185508'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '81185745'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '81196281'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '81671180'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '82327420'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '82106992'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '82072510'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '83201312'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '83201441'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '82217414'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '82825237'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '83235270'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '83742109'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '84093889'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '83746249'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '84300719'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '83949909'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '84032707'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '84032929'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '84924028'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '85058464'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '86028024'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '85823570'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '86031001'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '86210015'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '87178349'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '87178578'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '86116966'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '87296504'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '87178823'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '87191394'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88145665'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88601743'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '87869490'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88008643'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88037182'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88061127'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88062616'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88008880'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '88983546'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '89272446'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '89344918'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '90241397'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '90014200'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '90633057'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '91143404'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '90379197'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '90547376'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '91317110'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '90539354'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '91220160'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '91144149'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '91977052'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '92308060'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '92194605'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '92244187'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '92244478'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '92965298'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '93275825'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '92837246'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '94192205'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '93317139'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '94089445'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '94460064'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '94460357'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '94991861'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '95032882'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '94892929'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '95418760'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '95731969'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '96388855'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '96257726'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '96257918'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '96656649'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '96656966'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '97892067'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '98137036'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '96890832'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '97812938'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '98208390'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '98701878'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '99770165'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '99366093'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '99544344'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '100297522'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '100675692'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '100266788'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '100892678'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '101087814'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '101231725'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '101790079'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '102636256'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '103407899'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '103197955'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '103064900'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '104492920'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '103647492'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '103764262'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '104343949'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '105059976'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '105608745'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '106981543'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '105996715'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '106231159'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '106551000'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '107532466'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '107738280'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '108251419'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '108773252'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '108978768'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '109990342'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '109642179'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '110333057'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '110750410'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '111470052'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '110930284'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '112064600'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '112758318'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '113245479'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '113462883'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '113205553'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '113941481'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '113610461'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '114410161'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '115548278'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '114557993'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '116480632'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '116402633'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '118209193'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '118247809'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '118550393'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '121183908'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '119549219'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '121162434'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '120857603'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '121193701'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '121910396'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '123506961'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '123779165'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '123749557'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '124204664'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '126791028'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '126257992'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '126290403'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '127095575'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '129274332'
update archive13F set
compid = '159575',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004041'
where entryId = '129243880'
End Function
The Script is complete, exiting....