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: : 167134
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167134'
The Shares Amount is 9000000
The cusip is 70387R122
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '70387R122'
Number of Rows :3
update current13Fpositions set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479' ,
percentOut = '0.76'
where entryId = '131716146'
update current13Fpositions set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479' ,
percentOut = '0'
where entryId = '130475820'
update current13Fpositions set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479' ,
percentOut = '0.11'
where entryId = '132004578'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '70387R122'
Number of Rows :190
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '76432293'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '76883064'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '77011055'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '77176784'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '76986307'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '77648229'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '78330179'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '78095567'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '79584076'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '78868215'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '79067517'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '79153837'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '80045908'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '80050118'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '81135099'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '80579119'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '81256772'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '81335458'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '80893116'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '82036042'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '82741806'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '82767951'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '83323058'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '83622263'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '83387654'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '83905879'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '84867498'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '85078444'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '85210712'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '85353202'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '85657176'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '85759229'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '87435894'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '86675683'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '87321423'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '87448533'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '87551082'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '87758049'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '89289993'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '89036884'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '89423509'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '89541821'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '89603959'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '89631487'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '89956564'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '90169003'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '91355844'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '91621540'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '91612546'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '91583853'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '91474590'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '92165245'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '92369063'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '92903932'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '93151821'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '93628993'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '93423664'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '93531158'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '93607246'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '93640802'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '93914218'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '92526588'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '94209884'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95277481'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95446585'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95503907'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95622814'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95789313'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95989855'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95921622'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '96025552'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '95985411'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '96178430'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '97958587'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '96226283'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '97181187'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '97341162'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '97699305'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '98162405'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '98049227'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '98769078'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '98976954'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '99484015'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '99259506'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '99390360'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '99664737'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '100487242'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '100527654'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '100185553'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '99877799'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '101399562'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '102068341'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '102820291'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '101847074'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '102142533'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '102317645'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '101910164'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '102188408'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '102856851'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '103097173'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '103219217'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '103716389'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '103774422'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '104054303'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '104442335'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '105372866'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '104453645'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '104942381'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '105013352'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '105470640'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '105319822'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '105513917'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '104547387'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '107132860'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '107745168'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '106453410'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '106994578'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '107389224'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '107870633'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '108248166'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '107178029'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '107464932'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '108823321'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '110587634'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '109262003'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '110268288'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '109118424'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '109753044'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '108827123'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '109168171'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '110404886'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '110528644'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '111595237'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '112076691'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '113171172'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '112053434'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '112494028'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '111928843'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '112465866'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '112876594'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '113471864'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '113485420'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '114527574'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '114885500'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '114404053'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '114419541'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '115678847'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '114641986'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '114533919'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '114969988'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '116955057'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '118141492'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '116608349'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '116891588'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '117389771'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '118534896'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '116500674'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '117602571'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '116909526'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '118783405'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '119164374'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '120195822'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '120867757'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '121206643'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '119908061'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '120712465'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '119666574'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '121383000'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '122460180'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '121840691'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '122178751'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '122641548'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '123237958'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '123276754'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '122620679'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '123501340'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '123255537'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '124642789'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '124466666'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '125731973'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '124938155'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '125041541'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '125448760'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '126846344'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '126515535'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '127864933'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '129868902'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '129750115'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '128447567'
update archive13F set
compid = '167134',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006479'
where entryId = '127977925'
End Function
The Script is complete, exiting....