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: : 167133
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167133'
The Shares Amount is 9000000
The cusip is G79448117
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G79448117'
Number of Rows :1
update current13Fpositions set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478' ,
percentOut = '55.56'
where entryId = '95876657'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G79448117'
Number of Rows :304
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '90281566'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '91264136'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '91449578'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '91245647'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '91568230'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '91675853'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '90745135'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '94180107'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '92155593'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '92707196'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93338061'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93651755'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93798228'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '92801328'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '92903695'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93152649'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93542655'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93826918'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93327811'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93459990'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93532993'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93535560'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93586000'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93611583'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93639875'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93647791'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93682996'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93723586'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93725297'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '93746032'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '94000090'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '94350521'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95278313'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95058684'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '94459907'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '94514099'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '94871370'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95092479'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95111073'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95985939'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95584429'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95446045'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95484836'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95529753'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95845736'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95989529'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95918828'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95408496'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95476996'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95531936'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95689958'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95741259'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95810468'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95812638'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95816403'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95816553'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95871774'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95876376'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95917605'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95922283'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95935677'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95993536'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95952784'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95953556'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95959803'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '95478365'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '96499745'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97011106'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '96227158'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97573445'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '96887474'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97029763'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97180653'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97322677'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97366970'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97399829'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97438703'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98145937'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98239551'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98243444'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98469205'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '96768482'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97144043'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97183291'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97386560'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97769163'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97830508'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97874855'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98164442'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97920918'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98166099'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97931267'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97939543'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97990622'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97996611'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97997861'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98045685'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98051411'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98058866'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98104195'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98106269'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98183774'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98131346'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98203667'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '97823021'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99719462'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98756214'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100658809'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99286528'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99484324'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99515968'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99517956'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100130553'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99806617'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99818999'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100844730'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '98927128'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99260484'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99391676'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99471138'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99595133'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99663995'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99903005'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100610118'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100399347'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100528303'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99852641'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99936552'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100266087'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100626467'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100360144'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100380253'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100395064'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100396473'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100635987'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100413750'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100462512'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100467760'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '99526406'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100469834'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100487079'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100649462'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100539707'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100558188'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100568580'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100569722'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100422917'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '103959570'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100600465'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '101103772'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '101691332'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102451427'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102385576'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '103055648'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '101712985'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '101586218'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102143569'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102437898'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102235121'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102814277'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102222791'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102630861'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102079955'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '101933370'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102069418'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102189714'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102378403'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102582818'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102657818'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102686119'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102693948'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102701363'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102735323'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102736714'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102752294'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102792839'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102798952'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102801825'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102875476'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102909905'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102930069'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102943079'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102943756'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102951529'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '103227329'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '103071803'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '101308029'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '102281608'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '100905847'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '103863298'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '103959876'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '103797899'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104055357'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104202593'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104790348'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104444716'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104552311'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104800752'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104232756'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104277426'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '104618031'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105014983'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105018738'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105088743'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105116767'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105120738'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105135121'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105162471'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105191831'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105286132'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105295171'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105296455'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105312920'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105317139'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105325087'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105385208'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105399171'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105423036'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105521386'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105437944'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105439847'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105707236'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105709385'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '105160415'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '106249897'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '106842321'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '106366113'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '106377838'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '106454526'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '106665946'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107041305'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107136110'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107559945'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107871884'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107948398'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107980925'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107003385'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107572810'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107098968'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107466756'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107470987'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107573548'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108094094'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107612705'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108068593'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107648438'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107649764'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107672250'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107700170'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107717830'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107814410'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107823058'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107827641'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107850176'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107927308'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107928212'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '107945348'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108002730'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108128963'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108261470'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110044801'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108746515'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108751458'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110022257'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110057435'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110019296'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110741049'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110544548'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110028742'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110743332'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110539294'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110725004'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '109986284'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '109685941'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '108988812'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '109718477'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '113439908'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110112399'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110874013'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110725790'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110732826'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110737166'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110403946'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110739590'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110719284'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110746546'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110531367'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110546492'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110759603'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110762852'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110765767'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '110675247'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '112742862'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '112775680'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '112380199'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '112796833'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '112807888'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '113471831'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '113485859'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '113487260'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '113439343'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '113594621'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '115974564'
update archive13F set
compid = '167133',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006478'
where entryId = '116045015'
End Function
The Script is complete, exiting....