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: : 166682
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166682'
The Shares Amount is 90000000
The cusip is 09090D111
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '09090D111'
Number of Rows :2
update current13Fpositions set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335' ,
percentOut = '2.78'
where entryId = '93901058'
update current13Fpositions set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335' ,
percentOut = '3.87'
where entryId = '112510414'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '09090D111'
Number of Rows :207
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '87494389'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '87904017'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89282541'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '88103038'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '88724537'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '88725063'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89044372'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89063461'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89097890'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89307628'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89353288'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89361525'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89381283'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89443464'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89475908'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89485609'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89549534'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89549961'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89636755'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89637357'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89639312'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89226131'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '90595626'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '90161611'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91444583'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91264163'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91173261'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91431735'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91245619'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91758394'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91760803'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91685681'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '90854262'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '89999081'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91620495'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '90947435'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91621296'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91504516'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91258364'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91382120'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91832917'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91777460'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91505361'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '91282790'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '92327349'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93790216'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '92535286'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '92369510'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '92801330'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '92904276'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '92914935'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93146599'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93336021'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93612568'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93455535'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93504795'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93544658'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93545548'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93612711'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93639740'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '93725229'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '94114125'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95272174'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95068090'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95387215'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95446586'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95454707'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95875095'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95591262'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95531921'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95812925'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95860301'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95876044'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95920640'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95922109'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '95994151'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '96550211'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '96220876'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97029582'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97181189'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97190498'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97318344'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97997426'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97024886'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97283652'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97931638'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97967550'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '98178143'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '98051188'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '97823015'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100102091'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '98598001'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '99515719'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100755611'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '99253616'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '99382422'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '99664739'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '99683847'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100122704'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100395470'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100437956'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100486690'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100360348'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '100613388'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '101988332'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '101712700'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '101681273'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102136292'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102317648'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102330778'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102180318'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102333581'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102734254'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102777367'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '102875177'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '103049020'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '103674541'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '104047832'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '104231024'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '104245270'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '104442337'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '104453905'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '105475588'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '105522791'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '105161376'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '105247273'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '105295688'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '105385003'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '106317240'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107132864'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '106077356'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '106446603'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107220042'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107028473'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107745602'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107828193'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107619369'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107619881'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107698856'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107765041'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '107927135'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '108823325'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '110363754'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '110438914'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '110257450'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '109768855'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '109111423'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '109319223'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '108896319'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '109550357'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '109660476'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '110738125'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '110752349'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '110524729'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '110648270'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '111595241'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '112043937'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '112124035'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '111814427'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '111921752'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '112243987'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '112799992'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '113484944'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '113260854'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '113321772'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '113171348'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '114527579'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '114878417'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '114393471'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '114438862'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '115627527'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '116078280'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '115699913'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '115419905'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '115422031'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '114625360'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '118407425'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '116946206'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '116608354'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '116880453'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '118141792'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '118345184'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '117389361'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '118058650'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '116493788'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '118056674'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '117634991'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '120209561'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '120195826'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '121241952'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '119898082'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '120705579'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '119951198'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '120492206'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '121398867'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '121076003'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '121074071'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123258339'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123257957'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123212274'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123864653'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123237959'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123250820'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123991819'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123934351'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '123984830'
update archive13F set
compid = '166682',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006335'
where entryId = '126770176'
End Function
The Script is complete, exiting....