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: : 151960
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151960'
The Shares Amount is 134946000
The cusip is 26852W103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '26852W103'
Number of Rows :41
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '1.22'
where entryId = '12170547'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.17'
where entryId = '12286880'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '90.2'
where entryId = '13242571'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.04'
where entryId = '13968392'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '16285238'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.07'
where entryId = '16763112'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '17035439'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.09'
where entryId = '17468226'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.21'
where entryId = '17557582'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '17671773'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '17776225'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '18273550'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '18355461'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.16'
where entryId = '19053128'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '19236353'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '20763412'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.07'
where entryId = '23159243'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '7.25'
where entryId = '23170446'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '30.03'
where entryId = '23458423'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '24520144'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '24921634'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '24928678'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '62.7'
where entryId = '28047063'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '12.6'
where entryId = '29446574'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.67'
where entryId = '29669378'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.97'
where entryId = '36706022'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '37905370'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '72'
where entryId = '42089219'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '93.41'
where entryId = '42179508'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.24'
where entryId = '42204100'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '42455953'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '42466378'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0.67'
where entryId = '47250857'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '1.28'
where entryId = '51210326'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '11.21'
where entryId = '56364368'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '3.91'
where entryId = '57878423'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '59481651'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '0'
where entryId = '60058128'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '50.71'
where entryId = '60279175'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '22.66'
where entryId = '62204586'
update current13Fpositions set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658' ,
percentOut = '6.04'
where entryId = '62698448'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '26852W103'
Number of Rows :81
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '47197989'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '67780706'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63447491'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63529167'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63450760'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63449016'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63451496'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63523926'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63524313'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63651423'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63652436'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63752080'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64991563'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64104364'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63650579'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63758181'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64967571'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64948744'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64109225'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63752852'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64942659'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64930366'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64103286'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64114586'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64920786'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63528628'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64116361'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64111388'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64967240'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64991248'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64312331'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64108552'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64107423'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64317277'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64316151'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63651901'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64110079'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64106301'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64315639'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64972802'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64971517'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64971508'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64949342'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64319155'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64936654'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64303630'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64970827'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63451723'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64315223'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64973840'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64972633'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64971114'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64955604'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64942849'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64931212'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64931590'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64929482'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64927072'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64927901'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '63757401'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64926875'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64925778'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64924158'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64924021'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64923906'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64922699'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64921070'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64920420'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64923852'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64919373'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64918526'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64918167'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64933911'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64935392'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64968279'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64920556'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64919750'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64921220'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '64929132'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '51036971'
update archive13F set
compid = '151960',
sectorNum = '304002',
sectorDes = 'Property Management',
issuerCik = '0001405658'
where entryId = '96632520'
End Function
The Script is complete, exiting....