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: : 159767
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159767'
The Shares Amount is 9000000
The cusip is 45823T106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '45823T106'
Number of Rows :3
update current13Fpositions set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233' ,
percentOut = '0'
where entryId = '35982207'
update current13Fpositions set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233' ,
percentOut = '79.97'
where entryId = '130635537'
update current13Fpositions set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233' ,
percentOut = '0'
where entryId = '131376691'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '45823T106'
Number of Rows :65
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '66747439'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '66810171'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '67382750'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '65079581'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '65515921'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '66394526'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '63386660'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '63420019'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '64675392'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '68413193'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '68542397'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '68909757'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '70082164'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '70098925'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '72079670'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '72000508'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '72095597'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '73836269'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '74762903'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '73956130'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '75818751'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '75752082'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '78588413'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '79860112'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '81720038'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '81820734'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '83804358'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '83758696'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '84934983'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '85843073'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '85918796'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '87647860'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '87796922'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '88471436'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '89931312'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '90803446'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '92048891'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '92052887'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '92168032'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '94095354'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '94133646'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '94213141'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '96115828'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '97413611'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '99918546'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '101424110'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '101981064'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '104634465'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '103892947'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '106101464'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '106737618'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '109805166'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '110350315'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '111681325'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '113512217'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '114167126'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '116041845'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '116658755'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '119241944'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '119203859'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '123070971'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '123207660'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '124596704'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '127685783'
update archive13F set
compid = '159767',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004233'
where entryId = '129592684'
End Function
The Script is complete, exiting....