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: : 160390
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160390'
The Shares Amount is 95130000
The cusip is 74347Y771
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '74347Y771'
Number of Rows :61
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '131361121'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130019334'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130116643'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '124637539'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.21'
where entryId = '132343889'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130722512'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130438727'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.05'
where entryId = '130333957'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '5.47'
where entryId = '130650558'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.05'
where entryId = '127631561'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '52.75'
where entryId = '131781231'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '35.89'
where entryId = '132005496'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130107280'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.03'
where entryId = '131669159'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '131981249'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132628882'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '33.89'
where entryId = '132243070'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '2.08'
where entryId = '131932223'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132544079'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '14.45'
where entryId = '131576789'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '13.11'
where entryId = '131178316'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '1.05'
where entryId = '132207968'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '1.98'
where entryId = '131649779'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130200684'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132566105'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '50.24'
where entryId = '130315740'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '91.66'
where entryId = '131652276'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.15'
where entryId = '131418519'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '2.94'
where entryId = '130524491'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '129882817'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.03'
where entryId = '130272743'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.01'
where entryId = '128526146'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '131239500'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '151.46'
where entryId = '131492610'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130440594'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.13'
where entryId = '125210503'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130193996'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.02'
where entryId = '130554796'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.01'
where entryId = '131156587'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '139.07'
where entryId = '132303851'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '16.82'
where entryId = '131827732'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.56'
where entryId = '131716884'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130476358'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '131377115'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '1.75'
where entryId = '132689098'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.05'
where entryId = '131823859'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132546133'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132617025'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '1.18'
where entryId = '131672984'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132597657'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132582997'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130016143'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130275923'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '130736364'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132597771'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '4.2'
where entryId = '132361960'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.05'
where entryId = '132394919'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.05'
where entryId = '132489129'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.18'
where entryId = '132494879'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0'
where entryId = '132513695'
update current13Fpositions set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548' ,
percentOut = '0.01'
where entryId = '132519496'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '74347Y771'
Number of Rows :150
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '121583912'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '121936260'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '121469882'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '121514683'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122460726'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122076282'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122138759'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '121942711'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122675353'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124120258'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '121711832'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122223971'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122937441'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122642270'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123073098'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122168996'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123526338'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122981641'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122792954'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123437775'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123626886'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123426769'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122214466'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123661601'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123277764'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123385480'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123119010'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122382695'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125008966'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122974806'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123125223'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123815521'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124035751'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123430787'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '123692729'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '122478491'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124242684'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125232915'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124285596'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124397757'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124844011'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124342936'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124367949'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124801920'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124381337'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124752960'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125244245'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124619850'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125192949'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126243138'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126927320'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124467208'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124946507'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125042256'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125265422'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125390281'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124666632'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126776564'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124433666'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124951634'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124963954'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125412855'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125449781'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125623059'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126867175'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125693063'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125695752'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125702024'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125704414'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125797276'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126773589'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125981797'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126818141'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126035935'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126216410'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126291549'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126335194'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126412989'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126452919'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126468451'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126491160'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126502375'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126515892'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126522149'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '126900346'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '125538031'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128392165'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128171165'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '124371149'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127247810'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127295206'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127674134'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127581249'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127648123'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127626269'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127391113'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127393188'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127491623'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '130722138'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129726567'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127120467'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129818686'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127459347'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127865475'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127559992'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129713312'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129424051'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128164458'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128308947'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129287552'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129683438'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127884073'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127789920'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128470088'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128195067'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128990354'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129320368'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129692602'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128672195'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129763649'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129616968'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129409157'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128661806'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129375874'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129810169'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128883937'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129692062'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129792087'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129075757'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128777770'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128161888'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128020126'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128833707'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129748421'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128092060'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128866455'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128592677'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129746974'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129275702'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128448519'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129023930'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129693863'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127311750'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129622395'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128256541'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '127978698'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129528529'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129693941'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '128659485'
update archive13F set
compid = '160390',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004548'
where entryId = '129093177'
End Function
The Script is complete, exiting....