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: : 142474
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142474'
The Shares Amount is 947234000
The cusip is 200300507
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '200300507'
Number of Rows :9
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '0.18'
where entryId = '763758'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '2.22'
where entryId = '10023439'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '11.2'
where entryId = '11341443'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '21.25'
where entryId = '14355499'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '21.6'
where entryId = '16050033'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '47.27'
where entryId = '17097670'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '50.31'
where entryId = '18650595'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '0.92'
where entryId = '20167824'
update current13Fpositions set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301' ,
percentOut = '0'
where entryId = '73123376'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '200300507'
Number of Rows :33
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '66037736'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '67855373'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '68024197'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '67744052'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '67701331'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '66365588'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '68040224'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '67820154'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '66284753'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '66003415'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '66305655'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '69802182'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '69334735'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '69610955'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '69544719'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '69967343'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '71105305'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '71278247'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '71607181'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '71188778'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '71743303'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '72134536'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '72539268'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '73599426'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '73323403'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '74204603'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '74482530'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '75456381'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '75061349'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '76044491'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '76763335'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '77629164'
update archive13F set
compid = '142474',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000022301'
where entryId = '77620958'
End Function
The Script is complete, exiting....