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: : 160352
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160352'
The Shares Amount is 1940000000
The cusip is 23381D102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '23381D102'
Number of Rows :16
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.56'
where entryId = '42148887'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0'
where entryId = '92308989'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0'
where entryId = '130425551'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0'
where entryId = '130444905'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.38'
where entryId = '131136252'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.01'
where entryId = '130009126'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0'
where entryId = '130718169'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.01'
where entryId = '111394879'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0'
where entryId = '130661210'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.17'
where entryId = '130401823'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.04'
where entryId = '132320680'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0'
where entryId = '130916232'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.13'
where entryId = '131087937'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0'
where entryId = '132390563'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.03'
where entryId = '132477031'
update current13Fpositions set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156' ,
percentOut = '0.35'
where entryId = '132490579'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '23381D102'
Number of Rows :239
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '68150429'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '67183804'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '67502415'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '66752087'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '67086187'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '66431266'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '66625295'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '66520835'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '65170344'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '63614339'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '63649408'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '64700777'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '64867697'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '70007431'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '68619951'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '69664300'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '69864179'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '70326547'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '70832696'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '70107807'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '70907060'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '71154598'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '72194764'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '72074223'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '72221876'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '73154065'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '73309716'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '74777631'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '74055464'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '74428656'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '74230784'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '74879280'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '75045225'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '75925226'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '75886294'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '76316987'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '76723360'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '77162330'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '76973351'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '76811757'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '77684436'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '77750935'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '78049948'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '79053510'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '78202022'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '78836196'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '79592537'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '79930456'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '79877791'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '79806135'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '80361774'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '79701505'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '79715483'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '80151675'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81170911'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81000739'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '80930418'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81667982'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81724202'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81823754'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '82108319'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '82457819'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81916079'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81989322'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '81960465'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '82233228'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '82616594'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '83636688'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '83676758'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '83810349'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '83773276'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '83882876'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '83943512'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '83775726'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '85746907'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '84650789'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '84849106'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '85278662'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '85465350'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '87678272'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '85757993'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '85885635'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '85926263'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '86607312'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '86040207'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '86561137'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '86576311'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '86919127'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '86836113'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '87179764'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '85982599'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '87834546'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '87897055'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '88055243'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '88065915'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '87936961'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '88077398'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '88469413'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '89688125'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '87942286'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '89273375'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '89836381'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '88570049'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '89998779'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '89861567'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90646558'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90059132'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90071380'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90310748'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90814011'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90280258'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90056010'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '91824733'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '90616057'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '91827323'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '91145071'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '92022981'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '92195430'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '92328276'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '92988843'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '92568954'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '93782915'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '93730787'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '93276739'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '93865126'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '94014970'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '94221346'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '94346316'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '94371586'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '95166788'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '94571780'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '94893854'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '95613038'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '96011392'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '96039794'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '96591806'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '96494221'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '96550256'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '96558363'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '97230211'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98210433'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '96891776'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '97827615'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98414043'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98785804'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98598105'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98494157'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '99539777'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98630992'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98724267'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '98805438'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '100305878'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '100267745'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '100815642'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '101138285'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '100935456'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '103119306'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '101511809'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '101878370'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '102400822'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '102387990'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '103197705'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '102643961'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '103291893'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '103539706'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '103385774'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '104805676'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '104812753'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '104647707'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '105531237'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '103936962'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '106038929'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '106359854'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '108076715'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '108271815'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '107550485'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '108544002'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '109899834'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '105734390'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '109840349'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '110349305'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '112524255'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '111761686'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '112082050'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '111654374'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '113374128'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '113388362'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '113511234'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '114200869'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '113559741'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '114424746'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '114769979'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '114658556'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '115555001'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '116041319'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '115865159'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '116185680'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '117207658'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '118419063'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '117192306'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '116913985'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '118539944'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '120393886'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '120681072'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '119493135'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '119849505'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '120872922'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '118456229'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '121438365'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '121938530'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '122315168'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '122261170'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '122176020'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '122768661'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '123901780'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '123872792'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '122597759'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '122624759'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '124637579'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '124883349'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '125379137'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '125736244'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '124829588'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '125127591'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '125711916'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '125292277'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '126518719'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '126632443'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '127770351'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '127768113'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '127715821'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '128235176'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '129682338'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '128095576'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '129212748'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '128375597'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '129864204'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '129618212'
update archive13F set
compid = '160352',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001340156'
where entryId = '129750531'
End Function
The Script is complete, exiting....