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: : 160353
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160353'
The Shares Amount is 1540000000
The cusip is 34959A206
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '34959A206'
Number of Rows :10
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0.04'
where entryId = '132320065'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0'
where entryId = '92308990'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0.18'
where entryId = '130401851'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0.02'
where entryId = '130102494'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0.01'
where entryId = '130009470'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0.14'
where entryId = '131088363'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0'
where entryId = '111395073'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0'
where entryId = '132212673'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0'
where entryId = '130916483'
update current13Fpositions set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325' ,
percentOut = '0'
where entryId = '130444951'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '34959A206'
Number of Rows :211
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '67775801'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '67502805'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '67577128'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '66720509'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '65955879'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '66625689'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '65064618'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '63379667'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '64868100'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '68405401'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '69997087'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '68619983'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '68924130'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '69689542'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '69864562'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '70082116'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '70076386'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '70326581'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '70109412'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '70689331'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '70863928'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '70907551'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '71154988'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '72000459'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '72074256'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '72223522'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '73154599'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '73310103'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '73956087'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '74055496'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '74430480'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '74879818'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '75045618'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '75886322'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '75795872'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '76318897'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '76973735'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '76812275'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '77749646'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '77750963'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '78051377'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '78836590'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '79592017'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '79929982'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '79806159'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '79703418'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '79715487'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '81171294'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '81001266'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '82108322'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '82318437'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '81916104'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '81991279'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '81960560'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '82233613'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '82617068'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '83884821'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '83943537'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '83858835'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '83775728'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '84651270'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '84849498'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '85479040'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '86060762'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '86607801'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '86040230'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '86561139'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '85984587'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '86919617'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '86836331'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '87180150'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '88055262'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '88065917'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '87782378'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '87988041'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '88469493'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '89688330'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '87942756'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '89273773'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '89838592'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '88570531'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '88577556'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '90646814'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '90059151'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '90071381'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '90583129'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '90814631'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '90369824'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '91824662'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '90616268'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '91827805'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '91145466'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '91950409'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '92023075'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '92195420'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '92569610'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '92397814'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '93730997'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '92324021'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '93277130'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '93865103'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '93955009'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '94015066'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '94372272'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '94453685'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '95166991'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '94571788'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '94894245'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '95097650'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '95613319'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '96006895'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '96039896'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '96592011'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '96559083'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '97230418'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '96248029'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '97407102'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '96892171'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '97827937'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '98256530'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '98409566'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '98786569'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '98494359'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '100659423'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '99133505'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '98724500'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '99910786'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '100306297'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '100268141'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '100715791'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '100816443'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '101138484'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '101209610'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '101878653'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '100993817'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '101974177'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '103197797'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '102644385'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '103290227'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '103291972'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '103385980'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '103968283'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '104816774'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '104497890'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '71998607'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '105403920'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '105531674'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '106039134'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '106359885'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '107250171'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '107227656'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '107622240'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '107550933'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '108058547'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '108544213'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '108601004'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '109899865'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '109418442'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '109597862'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '110349781'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '111263391'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '111761716'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '112080867'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '112186344'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '112316466'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '113511704'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '114200900'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '114343845'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '114424978'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '115555244'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '115323325'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '116041561'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '116185711'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '118643909'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '116520838'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '117192467'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '118587427'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '116914242'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '118538629'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '120681227'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '119800797'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '119493164'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '119525031'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '119851105'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '120873059'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '119737368'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122315197'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122261320'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122066105'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122176150'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122769100'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122599356'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122483629'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '122626074'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '124084264'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '124883377'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '125379126'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '124943873'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '124829743'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '125128024'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '125713558'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '125551338'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '125736472'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '127770687'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '127715849'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '128235335'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '128096005'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '128375784'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '129864459'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '129848351'
update archive13F set
compid = '160353',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001444325'
where entryId = '127680735'
End Function
The Script is complete, exiting....