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: : 159576
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159576'
The Shares Amount is 8620000
The cusip is 00170F209
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00170F209'
Number of Rows :3
update current13Fpositions set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042' ,
percentOut = '34.12'
where entryId = '131163121'
update current13Fpositions set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042' ,
percentOut = '2.79'
where entryId = '132095240'
update current13Fpositions set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042' ,
percentOut = '27.9'
where entryId = '131613590'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00170F209'
Number of Rows :85
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '67062723'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '67543874'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '67539830'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '68297516'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '68136289'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '67177186'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '66231470'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '65584474'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '65396380'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '66070883'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '65438435'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '65371507'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '63525796'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '63744383'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '63956866'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '64074023'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '64996503'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '64483351'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '69220878'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '69910783'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '68726175'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '70239974'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '71369132'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '71030013'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '72654697'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '72381715'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '72893125'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '74040071'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '74958795'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '76532124'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '76906198'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '78495229'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '78766051'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '80275506'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '81560294'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '82377237'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '83667980'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '82032352'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '82679184'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '83790327'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '84783005'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '84934034'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '84591866'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '87521235'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '87647899'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '87041974'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '87914022'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '89750352'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '90146578'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '89811829'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '90078608'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '92151592'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '93217555'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '94243944'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '95342194'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '97249796'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '97707968'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '99755032'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '100201745'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '102400412'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '102345031'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '102557119'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '104812808'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '105526502'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '104512413'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '106920510'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '107780481'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '91934450'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '109625660'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '109184912'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '112900928'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '112339911'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '114344467'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '115572218'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '118223419'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '116839979'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '120280352'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '119801324'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '123419756'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '122953165'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '125659589'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '126267770'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '129258315'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '129173565'
update archive13F set
compid = '159576',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004042'
where entryId = '127901476'
End Function
The Script is complete, exiting....