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: : 159636
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159636'
The Shares Amount is 1940000
The cusip is 06740P114
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '06740P114'
Number of Rows :2
update current13Fpositions set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102' ,
percentOut = '44.78'
where entryId = '35073616'
update current13Fpositions set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102' ,
percentOut = '82.19'
where entryId = '89551557'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '06740P114'
Number of Rows :261
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '65051202'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68356088'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68054115'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '67856344'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '67319332'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '67568266'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '67892308'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68023821'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '65406206'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66364220'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66284277'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66350138'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66319952'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66732383'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66883036'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66129577'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66870911'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '66301161'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '65074151'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '65672831'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '65247238'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64141070'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64156807'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64502044'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64122563'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '63832501'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64182966'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64957766'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64590873'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64372841'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '64991674'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68409826'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68594493'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68505145'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68828180'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '68950865'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '69557178'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '69395061'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '69966935'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '70138663'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '70577043'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '70314578'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '70256410'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '71579739'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '70828552'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '71401999'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '71621668'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '71805606'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '72696413'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '72321436'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '73055556'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '72727161'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '72291276'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '73425649'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '73611064'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '73644224'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '74269638'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '74650962'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '74266861'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '74843753'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '74733332'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '75248013'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '75465993'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '75622850'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '75060023'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '75995271'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '75971324'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '77517690'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '77003500'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '77310336'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '77380269'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '77306292'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '77295879'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '76173761'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '79575817'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '77937216'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '78492872'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '79421540'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '78636091'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '78668410'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '78860627'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '79538676'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '79535514'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '79209489'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '79291566'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '80416284'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '80202460'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '80897960'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '80833764'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '81127391'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '80991221'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '81014940'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '81332885'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '81343947'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '81379962'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '83545315'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '82468721'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '82345189'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '82734608'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '83051836'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '83069380'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '83394636'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '83439205'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '83385529'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '84459135'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '84640963'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '84680496'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '84859945'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '85238482'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '85301869'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '85665124'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '86510176'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '86907984'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '86668145'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '86955481'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '87457497'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '87681497'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '87811964'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '88813505'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '89282386'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '88560295'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '89155894'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '90112507'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '90161443'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '90257752'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '90283695'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '90910174'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '90947289'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '91873732'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '92612475'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '93701467'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '92536702'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '92650660'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '92231911'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '93146472'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '93528003'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '95272043'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '94755510'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '94862493'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '95069251'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '95144161'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '94929400'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '95866480'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '98139771'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '96220745'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '96715087'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '96878536'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '97319638'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '97479376'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '98371356'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '99831610'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '99983216'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '100456166'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '99208144'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '99253478'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '99382248'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '100596036'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '102419507'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '101446500'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '102136154'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '101383259'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '102101025'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '101906304'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '102180147'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '104570113'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '103914582'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '104030577'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '104047685'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '105003140'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '105279553'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '105439187'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '108128935'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '106317065'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '106013248'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '106446446'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '108269860'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110708382'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '103698556'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '108086118'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '108053824'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '108139995'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '108312374'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '109695350'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '109709866'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110146642'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110498726'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '109111261'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110692900'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '108896168'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110818186'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110704681'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110092985'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110524626'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '110708504'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '111637589'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '112631316'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '112657740'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '112412795'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '112043684'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '111921590'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '112335524'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '112565482'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '113250325'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '113347698'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '113498527'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '111878872'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '113782979'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '114112229'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '114112353'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '114878251'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '114393247'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '115567700'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '115837130'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '112655449'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117396601'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '115765433'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '115601870'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '114596379'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '114231563'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '116092498'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '116385506'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '116385850'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117471455'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117149661'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117567415'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '116880215'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117251599'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117387032'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '116493634'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117903896'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '118357630'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '118576178'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '118831102'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '119150762'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '119151020'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '119575811'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '119589880'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '120964173'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '119784739'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '120436421'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '119897871'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '120705425'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '121253586'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '121633333'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '121792337'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '121788703'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '123258178'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '123256745'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '123247672'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '124000369'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '123243601'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '124082299'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '117334244'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '127303025'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '129647356'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '129647819'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '129648935'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '129650254'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '129651458'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '129652574'
update archive13F set
compid = '159636',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004102'
where entryId = '129669997'
End Function
The Script is complete, exiting....