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: : 151571
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151571'
The Shares Amount is 11327000
The cusip is 30247C400
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '30247C400'
Number of Rows :20
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '13.45'
where entryId = '42105797'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '20.31'
where entryId = '42110180'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '636.71'
where entryId = '42155316'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '63.9'
where entryId = '42171726'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '7.06'
where entryId = '42174696'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '7.36'
where entryId = '42224524'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '69.92'
where entryId = '42252714'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '0'
where entryId = '42463543'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '9.67'
where entryId = '46116773'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '10.4'
where entryId = '47143360'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '2.12'
where entryId = '51210720'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '3.47'
where entryId = '51751320'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '17.3'
where entryId = '56364541'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '213.41'
where entryId = '60347947'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '134.74'
where entryId = '64039805'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '17.75'
where entryId = '64628763'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '152.2'
where entryId = '65689897'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '3.64'
where entryId = '65706056'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '21.21'
where entryId = '65720007'
update current13Fpositions set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446' ,
percentOut = '251.42'
where entryId = '65836277'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '30247C400'
Number of Rows :230
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66040148'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66163254'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67883802'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67945900'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68009790'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67761067'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67502712'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67941339'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67495343'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67671163'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65656113'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67485247'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67702696'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68229865'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68353392'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67408756'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67872757'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68271754'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66178865'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66017720'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68243455'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67616995'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66097280'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67963526'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67564178'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67174774'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66616096'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66949406'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67586359'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68001662'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67508260'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68185268'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67822607'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67997247'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68280163'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68143197'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67592608'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68260370'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66984516'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67236571'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65491740'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67478647'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67181005'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67083459'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65040380'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66460982'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67787703'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67446004'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66423368'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68072923'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67552401'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67581631'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66783316'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68168866'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67209327'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68367917'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66078847'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66525748'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66221116'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66194053'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66023727'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66172827'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67095635'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67795276'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66109261'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66367040'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67536451'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65922412'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67928597'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67802895'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66265505'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66246578'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67812936'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67057530'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67274117'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67692272'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66638067'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66203589'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67923539'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '67536579'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66119085'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66872401'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66795994'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68181301'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66773975'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66920834'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66004999'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65207938'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65866775'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66206854'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66597588'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65544668'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66625595'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65830907'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65350884'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66478105'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65457060'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '66540791'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65846120'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65403416'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65643846'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65730956'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65018123'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65820203'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65856928'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65184704'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65884015'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65292893'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65433515'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65485204'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65932220'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65839988'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65164840'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65795870'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '65834044'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63454813'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63462805'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63780607'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63756223'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63724280'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63986764'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63924521'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63955057'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64874691'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64116392'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64007222'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64114078'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64304297'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64830527'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63942772'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64062178'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64097359'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64086673'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63641290'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63939049'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63976019'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64090635'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63962395'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63915761'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64255424'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63951974'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64522268'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63927459'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64388879'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64071140'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64272880'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64238161'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63789448'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64529857'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64755634'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64471244'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64425831'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64806900'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64938199'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64936142'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64430983'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64503797'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64823277'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64458268'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64925844'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64348726'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63931234'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64922363'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64922800'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '63371744'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64692154'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64153173'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64362292'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64918955'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64734239'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64651736'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64932358'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64857023'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64868001'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64904963'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '64838698'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68487405'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68493850'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68911065'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68907017'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68803162'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68576499'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69168949'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68906919'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69938211'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68706945'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68907286'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68907116'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69185225'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69175819'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69185924'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69359492'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69939146'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69939714'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69940106'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69934451'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69179294'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69940856'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69938643'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69933628'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69184800'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69184968'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69939832'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69903864'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69938799'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69361040'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69941020'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69359851'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '70043662'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '70046923'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69347305'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69930089'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69905860'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69169770'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '68912783'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69894494'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69905347'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69908913'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69930350'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '70044076'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69926910'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69935052'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69938584'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '70048019'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69940508'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69939111'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69939329'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69940774'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '69938883'
update archive13F set
compid = '151571',
sectorNum = '302001',
sectorDes = 'Asset Management',
issuerCik = '0001371446'
where entryId = '73750564'
End Function
The Script is complete, exiting....