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: : 159823
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159823'
The Shares Amount is 9000000
The cusip is 06740P221
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '06740P221'
Number of Rows :5
update current13Fpositions set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289' ,
percentOut = '1.96'
where entryId = '51208141'
update current13Fpositions set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289' ,
percentOut = '1.66'
where entryId = '111142254'
update current13Fpositions set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289' ,
percentOut = '13.78'
where entryId = '69269468'
update current13Fpositions set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289' ,
percentOut = '8.16'
where entryId = '109509370'
update current13Fpositions set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289' ,
percentOut = '0'
where entryId = '118762540'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '06740P221'
Number of Rows :309
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '68054121'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '67700014'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '68023823'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '67817609'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '66821813'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '67688519'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '66586206'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '66284278'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '66035274'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '66364200'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '66319958'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '65765027'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '64590879'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '64631608'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '64918439'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '68910107'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '69799552'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '69609409'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '69557184'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '70047339'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '71402005'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '71187421'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '70994230'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '73425655'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '73322016'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '73191135'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '75248019'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '75315606'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '75456012'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '75060029'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '74923246'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77679106'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77678854'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77679369'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77173334'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '76868475'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77003488'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77380270'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77620867'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '78170026'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '77865015'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '78668409'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '78860641'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '79482970'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '79291567'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '79621410'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '79940429'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '80382259'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '80720273'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '81127390'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '80991230'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '81014941'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '81035783'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '81379963'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '82551908'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '82734607'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '83051816'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '83069381'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '83105361'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '83439206'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '84100490'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '84640940'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '84680497'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '84749763'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '84859946'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '85301870'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '85654000'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '86907973'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '85830105'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '86668150'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '86955482'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '87635798'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '87445454'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '87681431'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '88809031'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '89282385'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '88954654'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '89155895'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '89738531'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '90127588'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '90161444'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '90947290'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '91489717'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '92305892'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '93685012'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '92231910'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '93146473'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '93528004'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '95272044'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '94584978'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '94755495'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '95246390'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '95144162'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '95866482'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '97251891'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '96220746'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '96715083'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '96878535'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '97421311'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '97462592'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '98371357'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '99965476'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '100107335'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '100456167'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '99144207'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '99208153'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '99253479'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '100077570'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '100464709'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '101357517'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '101427953'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '102136155'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '102101046'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '101906305'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '101990501'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '103121327'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '103914583'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '104047686'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '104030580'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '105116163'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '105279554'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '105413169'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '103482214'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '105291940'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '105751846'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '105962087'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '106317067'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108215350'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '106446447'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '105871081'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '107370889'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108250864'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108211870'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '107440357'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '107453433'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108093996'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '107974513'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108140000'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108336353'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109919049'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108385366'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108407355'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108709858'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109626103'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108465225'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108579792'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108756049'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110082167'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108720789'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109830170'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108388167'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108848080'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110122291'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110146638'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109657462'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109387885'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108799209'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108839743'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109399252'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110257199'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109111262'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108716774'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '108876431'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111172253'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111202337'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110026937'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109550347'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '109678580'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110092986'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110164948'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110724140'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110424107'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110524628'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110600166'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110653096'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110660581'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110929237'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110943495'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111034629'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '110984824'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111039979'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111081021'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111434314'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111632492'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112135405'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111386981'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111627769'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111659999'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112579129'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112635980'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113438754'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112774316'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112043685'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113493540'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111217567'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111245302'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111550987'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111620644'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111636711'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111649816'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112745728'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '111921591'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112168270'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112373093'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112800239'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112565483'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112626425'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112832401'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112982919'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113120844'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113250328'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113489895'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113492443'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113347699'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113399129'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112753907'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113435892'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115646861'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113603284'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113587596'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114217975'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114223234'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115215658'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114144379'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114733829'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116061576'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114372740'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114878252'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114195500'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '112771383'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113839906'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113904574'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '113948271'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114773057'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115817065'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115943143'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115424728'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115896591'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115765435'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115615527'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114896451'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115601872'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115097239'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115895183'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115955878'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115193564'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114002848'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '115618880'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '114231560'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118708119'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118704511'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116193720'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116632517'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116155166'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116149509'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '117163713'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118638515'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118270912'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116693206'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118572666'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116880213'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '117316269'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '117251600'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116744395'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118448352'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116979260'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118696041'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116731288'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118553610'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118668806'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118445450'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '116493635'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '117800759'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118650703'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '117903895'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118357631'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '118254860'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '119172807'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '119575791'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '119188075'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '119264629'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120629901'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120528433'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120310238'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '121308721'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120021032'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120964172'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120538383'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '121402231'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120436422'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '119897870'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120705426'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120970127'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '121253588'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '120910928'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '121640772'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123258108'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123218698'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '122336686'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123256746'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123233979'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123233697'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '124000368'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123235343'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123998632'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123243593'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '123247349'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '124001564'
update archive13F set
compid = '159823',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004289'
where entryId = '124082135'
End Function
The Script is complete, exiting....