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: : 167148
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167148'
The Shares Amount is 9000000
The cusip is 733245112
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '733245112'
Number of Rows :1
update current13Fpositions set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493' ,
percentOut = '0'
where entryId = '100978001'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '733245112'
Number of Rows :64
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '96464984'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '96886605'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97076534'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97180627'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97256115'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97366952'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97399827'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97419231'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '98085793'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97769330'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97874793'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97893516'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97914021'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97931200'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97996030'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '97997836'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '98059056'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '98497175'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '98579495'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '98450403'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100087035'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100124589'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '99925561'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '99259745'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '99332940'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '99390720'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '99664741'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '99760074'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100105737'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100104469'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100621578'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100360083'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100632639'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100634339'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100637975'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100462018'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100645739'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100646707'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100488415'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100527662'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100540108'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100578763'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100186106'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '101169763'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '100977075'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102007647'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102430173'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102082496'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102439713'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102429128'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102437964'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102431000'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '102990177'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '103003131'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '103007591'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '103009294'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '103011837'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '103015982'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '103120957'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '103977818'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '113545422'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '113545605'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '113986787'
update archive13F set
compid = '167148',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006493'
where entryId = '116303456'
End Function
The Script is complete, exiting....