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: : 159642
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159642'
The Shares Amount is 2430000000
The cusip is 69366X100
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '69366X100'
Number of Rows :11
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0.1'
where entryId = '42149653'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '11.15'
where entryId = '42234722'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0.85'
where entryId = '53884358'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0.02'
where entryId = '130010677'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0.21'
where entryId = '131087311'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0'
where entryId = '111395805'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0'
where entryId = '103708097'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0.01'
where entryId = '130915925'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '0.2'
where entryId = '131061190'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '4.19'
where entryId = '129943434'
update current13Fpositions set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108' ,
percentOut = '1.58'
where entryId = '130223661'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '69366X100'
Number of Rows :287
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '68152616'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '67142432'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '66265275'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '66810307'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '67504183'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '66433453'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '66938434'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '65079715'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '68378861'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '66627076'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '65980650'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '65215295'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '63447437'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '63439126'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '63597075'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '64703080'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '64869489'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '68413326'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '68468494'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '69587453'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '69666596'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '69865922'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '67225784'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '69516322'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '70082291'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '70838166'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '70207464'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '71344531'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '71593867'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '70909105'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '71156422'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '72000632'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '72731671'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '72176521'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '72646912'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '72120368'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '73156378'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '73311548'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '73784315'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '72980412'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '73956252'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '74422566'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '74623588'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '75713773'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '74061652'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '74308917'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '74881595'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '75047071'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '75818714'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '75766093'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '76611752'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '76723055'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '76662570'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '75964833'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '76975169'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '76520423'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '76813859'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '78142337'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79492805'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '77876149'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '78047115'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79571382'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '78201711'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '78555977'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '78838050'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79029556'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79591930'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79805138'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79694049'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '80144539'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '80362189'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79698774'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79816393'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81172752'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81243928'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81003104'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '79779891'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81668279'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81720141'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81896384'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '83560993'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81931972'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81986475'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '82101609'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81852692'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '82449586'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81942820'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '81960870'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '82011591'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '82235076'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '82313795'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '82618826'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '83677051'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '83738215'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '83758830'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '83880090'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84521547'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84805533'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84020009'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '83947855'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84010614'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84590083'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '85754592'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84301682'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84653026'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '84850958'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '85021864'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '85465047'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '85761099'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '85843205'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86060127'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '85758290'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86609244'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86543718'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87038861'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '85979859'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87273932'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86121002'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86313276'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86921376'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86115551'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '86835816'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87181589'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87834850'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87764722'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87773396'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '88596138'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87782149'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87987980'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '88061275'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '88629614'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '89687847'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '87944156'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '88784191'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '89275228'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '89831982'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '88572270'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '89861840'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '89931425'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '88577571'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90237951'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90629040'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90816411'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90631646'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90142135'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90854608'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90539499'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90373535'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '91824922'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '90615789'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '91829544'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '91146897'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92087391'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92116731'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92023302'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92048995'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92571481'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '93730519'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92965449'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92703247'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92856930'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '92389930'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '93278559'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '93328413'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '93864911'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '94015298'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '94132073'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '94019517'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '94374249'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '95033034'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '95166524'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '95202835'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '94809489'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '94895675'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '95244089'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '95612566'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96040131'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96066142'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96591528'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96376451'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96235602'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96561138'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96461511'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96851615'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '96893607'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '97827081'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '98414036'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '98399143'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '98788739'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '98493886'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '98563610'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '98644026'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '99346204'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '100305191'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '99754823'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '100269604'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '100818689'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '101138013'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '101049335'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '100785124'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '101002624'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '101917722'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '103057041'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '102176527'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '103197722'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '102643251'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '103290549'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '103541012'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '103386823'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '103561137'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '104512038'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '103975032'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '104144825'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '105530513'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '106039960'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '106114721'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '106694891'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '106948828'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '107000566'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '106225188'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '107549737'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '108545048'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '110348531'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '110001592'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '108946913'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '109268289'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '110502901'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '109214183'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '111637588'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '112339559'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '111313284'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '111952800'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '112083062'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '111654153'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '112941945'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '113510470'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '113847370'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '113774048'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '114338927'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '114087296'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '114425755'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '114633666'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '115036840'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '116043207'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '116582098'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '116511306'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '117029564'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '117712197'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '116398141'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '117192077'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '116915114'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '121183696'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '119139178'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '120680852'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '119838704'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '119525480'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '120873542'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '120604842'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '121910175'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '122139332'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '122260937'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '122768015'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '123630509'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '122566611'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '122484076'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '122625245'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '124204560'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '125737268'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '124829355'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '125702182'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '125126956'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '125551772'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '124524689'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '129637616'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '129668231'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '129648934'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '129669674'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '125971981'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '127095477'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '127771841'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '128372048'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '127931210'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '129710401'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '128094944'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '129863892'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '129848490'
update archive13F set
compid = '159642',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004108'
where entryId = '128087162'
End Function
The Script is complete, exiting....